I am trying to get a count for letters in a range of cells, however, I need it to ignore the formulas in the cells that do not produce a value.

Your question doesn't make sense. What do you mean by

"get a count for letters in a range of cells"?Are the "letters" the results of formulas?

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Yes - most of the cells contain the letter Y for Yes, if the cell doesn't have a Y in it, just the formula, it won't calculate my pecentenge at the end. Out of 12 cells I need to know how many inspections were completed, but if it wasn't completed the cell will show just the formula, and will still count the cell, I want it to ignore the formula when no result/value is produced. This is my formula

=COUNTA(D21:O21)/12*100

As per the Help files for COUNTA, the function counts the number of cells that are not empty in a range.If a cell contains a formula, it is not empty.

Look instead at the COUNTIF function in the Help files.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

I will try that - Thanks!!

It worked - Thanks so much!!!

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History