Sum using multiple criteria
 

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

One way:

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

In article ,
Barbara 1 <Barbara wrote:

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

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

Regards,

Peo Sjoblom

"Barbara 1" wrote:

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Barbara 1" <Barbara schrieb im
Newsbeitrag ...
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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Frank Kabel" schrieb im Newsbeitrag
...
Hi
try
=SUMPRODUCT(--(A1:A100={"AG","AD"}),B1:B100)

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Barbara 1" <Barbara schrieb im
Newsbeitrag
...
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