SUMIF multiple criteria
 

Hello follow up question;

I need my sumif to filter on 2 criteria,
sumif(a1:a12=b1)*(c1:c12) B1 being the account number,

then I need
sumif(e1:e12=f1)*c1:c14) F1 being a month

How do I combine the 2 formulas to make a single and if the results columns
(B1 & F1) are on a seperate sheet how would this work?

Hi
=SUMPRODUCT(--(A1:A12=B1),--(E1:E12=F1),C1:C12)

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

--
Regards
Frank Kabel
Frankfurt, Germany

"LOU" schrieb im Newsbeitrag
...
Hello follow up question;

I need my sumif to filter on 2 criteria,
sumif(a1:a12=b1)*(c1:c12) B1 being the account number,

then I need
sumif(e1:e12=f1)*c1:c14) F1 being a month

How do I combine the 2 formulas to make a single and if the results
columns
(B1 & F1) are on a seperate sheet how would this work?