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