Formula percent complete excluding given text string
I am doing a matrix and need help with a formula to exclude certain items
from a €śpercent completed€ť formula. I want to count the number of items in a
column of data except if the field contains the text €śNA€ť. Then the formula
should return a percent complete on fields that contain any other character
or number from the total number possible (again, excluding the €śNA€ť
characters).
Example:
=(Number of items with a character EXCEPT €śNA€ť)/COUNTIF(L3:L58,"<NA")
I got the first part of the formula from another posting, but cant figure
out how to get the number of items that have a response excluding €śNA€ť and
blanks. Any help you can provide would be much appreciated.
|