| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
text formulas
I have "Y,N,&NA" in one column. In another column off to the right I am
counting those inputs. A total is then calculating those Y(which formulate to be 100%) and N (which formulate to be 0%) and then averaging them. However, I don't want the NA to be part of the average. Meaning, if NA is input, then the count would be NA, instead of 0% (like the N). It throws off the average and I want it excluded from the avg calculation Any thoughts on how to get this to work?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding text in formulas | Excel Worksheet Functions | |||
| show text after formulas | Excel Discussion (Misc queries) | |||
| HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? | Excel Worksheet Functions | |||
| Excel formulas to create large blocks of text | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Threaded Mode
