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!!!
Ad Choices