Alternative for =countifs (in 2007) for Excel 2003

  • Thread starter Thread starter Longhag
  • Start date Start date
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to update edited values in validation list? 1
SUMIF? 9
countifs month criteria 6
countif for 2003 1
Excel Need Countifs Formula Help 0
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
conditions in if statements 1

Back
Top