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

Excel Need Countifs Formula Help 0
Multi-demensional frequency distribution 4
COUNTIFS 2
Countif Based on Date Range 3
Excel 2007 countifs function problem 2
countifs Function not giving desired result with date criteria 2
Using ? in criteria 2
Counting using multiple criteria 11

Top