Countif not blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to count a the number of cells in a range that are not blank.
=countif(a1:a14,"<>""") includes blank cells in its results.

I checked to see if the cells were actually blank by using
=countif(a1:a14,""),which counted the blank cells correctly.

Anybody got any ideas?

Thanks
 

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
SUMIF with criteria "<>" & "=" 4
Countif(Not blank) 3
If and Countif 2
Sumproduct not working 5
If with countif or counta 3
Countifs 2
How to tell COUNTIF to not count a few characters 2

Back
Top