View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default CountIF() & SumIF() with multiple criteria

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.