Sum using multiple criteria

[Guest]

What equation would I use to be able to sum a column based on multiple
criteria from another column? i.e..... sum if AG or AG

AG 50.00 Total
AD 25.00 75.00
DE 10.00
SG 45.00

 

[JE McGimpsey]

One way:

=SUMPRODUCT((A1:A4="AG")+(A1:A4="AD"),B1:B4)

 

[Guest]

See answer to your previous post, try to stay in the same thread

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100={"AG","AD"}),B1:B100)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Frank Kabel]

Hi
should be:
=SUMPRODUCT((A1:A100={"AG","AD"})*(B1:B100))