Posted to microsoft.public.excel.worksheet.functions

Nikki

external usenet poster

Posts: 184

SumIf and vlookup formula help

I have 5 categories that I need to sum but it is on another tab. I can't
remember how to use the Sumif and vlookup formula together.

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

a vlookup will only give me the first hit but I need all three totals for
product A so Product A = $500 instead of the first one it finds Product A =
$100

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
Do I need a sumif or sum of a vlookup formula?	PeterB	Excel Worksheet Functions	0	June 1st 05 12:23 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us