How do I countif the criteria is a nonblank?

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

Guest

A B
$10
$20 $20

How do I get a count of the cells in column B only for the nonblank cells?
Help will be appreciated!
 
Thank You. Wasn't sure which formula was for nonblanks. Helped alot.
Todd
 
You are very welcome. You could also count the blanks themselves with :

=COUNTBLANK()
 
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

Countif for 2 columns 3
Count NonBlank Rows with Criteria in another column 5
How do I count nonblanks in column A when I filter by column B 5
Countif with date range criteria 5
If and Countif 2
count nonblank cells 3
If with countif or counta 3
Get Last NonBlank Value 5

Back
Top