ExcelBanter - Countif question

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

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

- - Countif question (https://www.excelbanter.com/excel-worksheet-functions/71393-countif-question.html)

Dan B

Countif question

Hi,
I'm using this formula to count empty rows in a column:
=countif(A2:A1000,"")

In another column, I want to count the rows that are not empty. What do I
need to change in this formula to do that?

Thanks

PCLIVE

Countif question

Try this:

=countA(B2:B1000)

HTH,
Paul

"Dan B" wrote in message
...
Hi,
I'm using this formula to count empty rows in a column:
=countif(A2:A1000,"")

In another column, I want to count the rows that are not empty. What do I
need to change in this formula to do that?

Thanks

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