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

Try this:

=countA(B2:B1000)

HTH,
Paul

"Dan B" <[email protected]> wrote in message
news:[email protected]...
> 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
>