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" 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