Sumif and vlookup Help

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

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
 
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.
 
Hi Nikki
Maybe this : =SUMPRODUCT((A1:A7="Product A")*(B1:B7))
You need to adjust the range to your needs.
HTH
John
 
Back
Top