Thread
:
Sum using multiple criteria
View Single Post
#
4
Frank Kabel
Posts: n/a
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
Reply With Quote