use COUNTA()
--
Gary''s Student - gsnu200826


"Lynn" wrote:

Hi,
I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The
data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text.
Rows 2, 3, 6 & 8 are blank.
I want to count the total number of cells that have information in it
regardless of if it's text or numeric (of course not count the number of
blank cells) so the answer would be 5
is there a formula that can do that? does this make sense?

Thanks
Lynn