View Single Post
  #1   Report Post  
LOU
 
Posts: n/a
Default 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?