SUMIF multiple criteria

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Sumif multiple criteria? 3
horizontal sumif help 2
Sumif across multiple ranges 3
SUMIF where the criteria is 'if contains a string'? 5
Sumif Function 1
Combining several cells into single equasion? 1
Using SUMIF inside SUMPRODUCT => complex problem (suite) 1

Top