How do I countif the criteria is a nonblank?

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!
 
G

Guest

You are very welcome. You could also count the blanks themselves with :

=COUNTBLANK()
 

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
count nonblank cells 3
If and Countif 2
If with countif or counta 3
COUNTIF nonblanks 3

Top