Alternative for =countifs (in 2007) for Excel 2003
 

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...

Alternative for =countifs (in 2007) for Excel 2003
 

See previous thread. NOT good to start a new one

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Longhag" wrote in message
...
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...