SumIf and vlookup formula help

N

Nikki

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
 
J

Jacob Skaria

Try


=SUMPRODUCT(SUMIF(INDIRECT("'"& {"sheet1","sheet2","Sheet3"}
&"'!A:A"),"Product1",INDIRECT("'"& {"sheet1","sheet2","Sheet3"} &"'!B:B")))
 
S

Steve Dunn

Hi Nikki,

You don't need VLOOKUP at all, just SUMIF.

=SUMIF(Sheet1!$A$1:$A$5,"Product A",Sheet1!$B$1:$B$5)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to write a PRODUCT formula that mimics a SUMIF 3
VLOOKUP or SUMIF for Multiple Criteria 2
Match/Index/Sum function with date range 2
Vlookup and Hlookup help 3
SumIf and Vlookup together? 3
Vlookup for repitative data 8
Sumif and vlookup Help 2
Searching the formula (not the value) for a text string 1

Top