SumIf Question

  • Thread starter Thread starter Tasha
  • Start date Start date
T

Tasha

I have a list of names in cell a3:a25 and what to add the sum from column g.
please help
sumif (a3:a50,"Bob", g3:g50)
 
That looks right, that will add all values in G where the value in A is Bob.

Was there more to it?
 
If you want one formula to sum for 5 different names...
here are a couple approaches:
=SUM(SUMIF(A5:A50,{"alpha","bravo","charlie","delta","echo"},G5:G50))
or
=SUMPRODUCT((A5:A50={"alpha","bravo","charlie","delta","echo"})*G5:G50)

Also, you could reference a list, instead of putting the values in the
formula
Example:
I1:I5 contains this list:
Alpha
Bravo
Charlie
Delta
Echo

and the formula would now be a combination of the two above methods:
=SUMPRODUCT(SUMIF(A5:A50,I1:I5,G5:G50))

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 
Back
Top