Hi,

I need to count with two parameters, but I can't get it to work in excel 2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but when
I want to save the file as 97-2003 it pops up with Error on the formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael