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.

CountIF() & SumIF() with multiple criteria
 

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.

CountIF() & SumIF() with multiple criteria
 

G'day Biff

Thx you so much, you've saved me again

Regards
Mark.

CountIF() & SumIF() with multiple criteria
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"NoodNutt" wrote in message
...
G'day Biff

Thx you so much, you've saved me again

Regards
Mark.

CountIF() & SumIF() with multiple criteria
 

Thank you, Thank you, Thank you!!!!
--
Sharyn


"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"NoodNutt" wrote in message
...
G'day Biff

Thx you so much, you've saved me again

Regards
Mark.

CountIF() & SumIF() with multiple criteria
 

You're quite welcome!

--
Biff
Microsoft Excel MVP


"Sharyn" wrote in message
...
Thank you, Thank you, Thank you!!!!
--
Sharyn


"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"NoodNutt" wrote in message
...
G'day Biff

Thx you so much, you've saved me again

Regards
Mark.