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)

--
Biff
Microsoft Excel MVP


"NoodNutt" wrote in message
...
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.