Alternative for =countifs (in 2007) for Excel 2003

L

Longhag

This is my current 2007 formula in Excel 2007:

=COUNTIFS(A4:A302,2,G4:G302,"written")

I've tried =COVAR(A4:A302=1,G4:G302="written")
But is showing #DIV/0! once completed

Thanks for your help...
 
Top