COUNTA for Numbers and Text

[Accesscrzy]

I need to count how many rows have data in them... could be numbers, could be
text. I do not want to count blank cells.

I thought for the text I could use this =COUNTA(A1:A7,"<>TBD")
But I get an error.

1 TBD
2
3 123
4 TBD
5 123
6
7 123

This is the result I am looking for...
5 cells of data
2 cells have TBD
3 cells have 123

 

[Dave Peterson]

=counta(a1:a7)
will give you the quantity of non-empty cells in A1:A7

=count(a1:a7)
will give you the quantity of numeric cells in A1:A7

=countif(a1:a7,"TBD")
will count the number of TBD's

=countif(a1:a7,"<>TBD")
will count the number of cells different from TBD (probably not what you want)

 

[Accesscrzy]

Thank you Dave... I guess I need to throw some more text in the mix!
How do I get the count of non blanks and non TBDs (result should equal 4)
Basically, I am looking for =CountA(A1:A9,<>TBD)

1 TBD
2
3 123
4 TBD
5 ABC
6 TBD
7 123
8
9 XYZ

 

[Dave Mills]

How about =counta(a1:a7)-countif(a1:a7,"TBD")

Thank you Dave... I guess I need to throw some more text in the mix!
How do I get the count of non blanks and non TBDs (result should equal 4)
Basically, I am looking for =CountA(A1:A9,<>TBD)

1 TBD
2
3 123
4 TBD
5 ABC
6 TBD
7 123
8
9 XYZ

 

[Accesscrzy]

As usual.. you guys (and sometimes ladies!) came through again. Thank you
for being here.