| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula Minimum Excluding Text | Excel Discussion (Misc queries) | |||
| Track progress to lookup percent complete on another worksheet. | Excel Worksheet Functions | |||
| Percent Complete? | Excel Discussion (Misc queries) | |||
| Percent Complete? | Excel Discussion (Misc queries) | |||
| COUNTIF - everything excluding a string | Excel Worksheet Functions | |||
Threaded Mode
