Posted to microsoft.public.excel.misc

John[_22_] John[_22_] is offline

external usenet poster

Posts: 694

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP & SUMIF	Jock	Excel Worksheet Functions	7	April 2nd 23 07:53 PM
Vlookup + sumif , but how????	Jessejames	Excel Worksheet Functions	4	April 21st 10 06:41 PM
SUMIF - VLOOKUP	mcp201	Excel Discussion (Misc queries)	6	October 8th 09 09:00 PM
sumif or vlookup help	Katie	Excel Worksheet Functions	2	July 2nd 08 05:21 PM
vlookup, sumif, if, countif, help	chintu49	Excel Worksheet Functions	0	May 26th 05 03:00 PM

All times are GMT +1. The time now is 11:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us