Excel 2003 won't calculate that; COUNTIFS was introduced in Excel 2007. You
could code a UDF (which would run in 2007 in place of the new built-in
function, by the way), or you could use a good old array formula.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"HenderH" wrote in message
...
I have got a working spreadsheet in 2007 and I want to give a copy to a
colleague.

The problem is that he he still uses 2003

How do I get 2003 to do this "=COUNTIFS(A2:A300,F12,C2:C300,F17)"