CountIF() & SumIF() with multiple criteria

  • Thread starter Thread starter NoodNutt
  • Start date Start date
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.
 
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)
 
Back
Top