Use

=SUMPRODUCT(--($AB$3:$AB$150="12 mth"),--($AC$3:$AC$1500))

"kje.1953" wrote:

How can I use a count function in excel 2003 that does the same thing as
countifs in Excel 2007?

I created this multi criteria in Excel 2007 but it wont work in Excel 2003
as the rest of the team dont have the same version and it converts to
#NAME?.

I am trying to count the number of times where a particular criteria has
been used e.g. 12 Mth where there is a date in column AC

=_xlfn.COUNTIFS($AB$3:$AB$150,"12 mth",$AC$3:$AC$150,"0")

How can I use mutilpe criteria in Excel 2003 to do the same thing?
--
kje.1953