Formula To Count Cells With Visible Text

Hi all,

I have a column of cells (say N7:N149) for which I would like to count the number of times text is visible, as some are blank. Normally I would go =COUNTA(N7:N149), but in this instance the cells are only blank because I have related them to adjacent cells and nominated "" if those adjacent cells are blank, therefore when I use my =COUNTA(N7:N149) formula it gives me a total of 143 (149-7).

Is there a way to get around this?

Thanks in advance,
avendi

Oh, and apologies for the poor maths

hi,

Find the attached file.


Punnam

Hi Punnam,

Thank you for this. I understand your spreadsheet, but am having a problem substituting what you chose as "d" into my document, in which there is no specific letter to choose from, simply text. I tried the following, but it did not work:
=SUMPRODUCT((N7:N1048576="*")*(N7:N1048576<>""))
Cheers

Until unless u provide us a sample workbook with out any confidential data , it will be difficult to imagine which type of data is available in the said column
=SUMPRODUCT((N9:N35<>"0")*(N9:N35<>""))

Try this once

That did it, thanks very much to you both.

U r welcome avendi

I thick u are satisfied with the solution, so mark the thread as solved, using the thread tools.

U can thanks any who had helped u by adding reputation points using the star button .

Punnam