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