Ignorning a formula with no value

May 2, 2011 at 08:33:48
Specs: Windows Vista
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.

See More: Ignorning a formula with no value

Report •

#1
May 2, 2011 at 09:38:11
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.


Report •

#2
May 2, 2011 at 09:51:27
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


Report •

#3
May 2, 2011 at 11:41:22
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.


Report •

Related Solutions

#4
May 2, 2011 at 11:47:23
I will try that - Thanks!!

Report •

#5
May 2, 2011 at 11:51:26
It worked - Thanks so much!!!

Report •

Ask Question