COUNTIFS in earlier version of Excel 1

[LGMan]

Hi, have to use Excel 2003 at work and am haveing a little trouble!

Within 2007, I can use the COUNTIFS function in order to report on a couple of criteria from a large table.

it doesn't look like its supported in 2003 as I just get the #Value error.

For info within 2007 I'm using
=COUNTIFS(C4:C100,"=EX6",G4:G100,"=Sold")

Thanks in advance

 

[GlennUK]

=SUMPRODUCT(--(C4:C100="EX6")*--(G4:G100="Sold"))


Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[LGMan]

Thanks Glen much appreciated