Prev: Does anyone have a copy of a Payroll Chart when paid every 2 week
Next: Auto Row Height with Wrapped Text in Merged Cells Problem
From: Nikki on 3 Jun 2010 13:32
Can you please help me with setting up a formula?

Product A = $100
Product A = $100
Product A = $300

I want my result to be Product A = $500 not $100.

Please help...Thanks
From: Don Guillett on 3 Jun 2010 13:36
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Nikki" <Nikki(a)discussions.microsoft.com> wrote in message
news:5CE8136D-7E5E-4AC0-80F6-600AA85F24F5(a)microsoft.com...
> Can you please help me with setting up a formula?
>
> Product A = $100
> Product A = $100
> Product A = $300
>
> I want my result to be Product A = $500 not $100.
>
> Please help...Thanks

From: John on 3 Jun 2010 13:54
Hi Nikki
Maybe this : =SUMPRODUCT((A1:A7="Product A")*(B1:B7))
You need to adjust the range to your needs.
HTH
John
"Nikki" <Nikki(a)discussions.microsoft.com> wrote in message
news:5CE8136D-7E5E-4AC0-80F6-600AA85F24F5(a)microsoft.com...
> Can you please help me with setting up a formula?
>
> Product A = $100
> Product A = $100
> Product A = $300
>
> I want my result to be Product A = $500 not $100.
>
> Please help...Thanks

 | 
Pages: 1
Prev: Does anyone have a copy of a Payroll Chart when paid every 2 week
Next: Auto Row Height with Wrapped Text in Merged Cells Problem