ExcelBanter - How do I countif the criteria is a nonblank?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I countif the criteria is a nonblank? (https://www.excelbanter.com/excel-worksheet-functions/88906-how-do-i-countif-criteria-nonblank.html)

Todd

How do I countif the criteria is a nonblank?

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!

Gary''s Student

How do I countif the criteria is a nonblank?

Use COUNTA()

This function counts non-blanks
--
Gary's Student

"Todd" wrote:

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!

Todd

How do I countif the criteria is a nonblank?

Thank You. Wasn't sure which formula was for nonblanks. Helped alot.
Todd

"Gary''s Student" wrote:

Use COUNTA()

This function counts non-blanks
--
Gary's Student

"Todd" wrote:

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!

Gary''s Student

How do I countif the criteria is a nonblank?

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

=COUNTBLANK()
--
Gary's Student

"Todd" wrote:

Thank You. Wasn't sure which formula was for nonblanks. Helped alot.
Todd

"Gary''s Student" wrote:

Use COUNTA()

This function counts non-blanks
--
Gary's Student

"Todd" wrote:

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!

All times are GMT +1. The time now is 06:16 AM.