countifs criteria

A

Anvil22

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick
 

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

Word macro that can call cells out of Excel for a find and replace 0
Multi-demensional frequency distribution 4
countifs Function not giving desired result with date criteria 2
Countifs with if and date range 2
how to find text vaues for a given grade? 0
COUNTIFS 2
Countifs formula 2
Countif Based on Date Range 3

Top