How do I count column cells that are not blank

[hmho]

I have Excel 2007 and I would like to count cells in column that are not blank. There could be text or numbers in those cells for example below.

ColumnA
1233

13265
12365

In this sample there is three entry and one of them is blank so I would like to return it as 1

Thanks

[davesexcel]

you have 4 cells with data, 3 of them are not blank, how would you expect then result to be 1?

Try

=COUNT(ISBLANK(A:A))

Will get the 1 Blank result

[jeffreybrown]

Which is it, count blanks or non-blank?

Blank =COUNTBLANK(A1:A4) = 1

Non-Blank =COUNTA(A1:A4) = 3

[hmho]

Which is it, count blanks or non-blank?

Blank =COUNTBLANK(A1:A4) = 1

Non-Blank =COUNTA(A1:A4) = 3

How can also add condition on another column, so I want to count the not blank when column B in red.

ColumnA ColumnB
12345 Red

123654 Blue
126333 Blue

123655 Red
This should return me 2 since there are two cells in column A that is not blank but also column B is red.

Thanks

[jeffreybrown]

This should work...

=COUNTIFS(A1:A6,"<>""",B1:B6,"Red")

or

=SUMPRODUCT(--(A1:A6<>""),--(B1:B6="Red"))