Prev: Simple hack to get $500 to your home.
Next: Large list of numbers to concatenate
From: Nikki on 3 Jun 2010 11:55
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


From: Jacob Skaria on 3 Jun 2010 12:01
Try


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

--
Jacob (MVP - Excel)


"Nikki" wrote:

> 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
>
>
From: Steve Dunn on 4 Jun 2010 05:31
Hi Nikki,

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

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



"Nikki" <Nikki(a)discussions.microsoft.com> wrote in message
news:51E11272-AAF2-4C12-B01D-2FCC7D2232FC(a)microsoft.com...
>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
>
>

 | 
Pages: 1
Prev: Simple hack to get $500 to your home.
Next: Large list of numbers to concatenate