Thread: Alternative for =countifs (in 2007) for Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Longhag Longhag is offline
external usenet poster
  
Posts: 11
Default 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...
Reply With QuoteReply With Quote