CountIF() & SumIF() with multiple criteria

N

NoodNutt

G'day everyone

Need a little help with the following please.

Using 97-2003 format

=COUNTIF(AND('2008'!$B5:$B2004,"Eastern Creek",'2008'!$E5:$E2004,"VIC"))

Essential what I am need is to count only the records that match column B &
D.

=SUMIF(AND('2008'!$B5:$B2004,"Eastern
Creek",'2008'!$E5:$E2004,"VIC"),'2008'!$I5:$I2004))

Again match the 2 criteria, sum only that which matches in Column (i).

TIA
Mark.
 
T

T. Valko

Try these:

=SUMPRODUCT(--('2008'!$B5:$B2004="Eastern
Creek").--('2008'!$E5:$E2004="VIC"))

=SUMPRODUCT(--('2008'!$B5:$B2004="Eastern
Creek"),--('2008'!$E5:$E2004="VIC"),'2008'!$I5:$I2004)
 

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
Combine Sumif and Countif 3
COUNTIF? SUMIF? SUMPRODUCT? IF? 2
Using Countif with multiple worksheets 5
countif 2
Criteria length limit in SUMIF() 14
Countif & Sumif with Multiple criteria 6
Unique Counting With Multiple Criteria 8

Top