| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing and Averages with non-numeric cells
I have a 7 question survery with the following possible responses
1 2 3 4 5 N/A We then take ther responses and average them. I'd like to eliminate the N/A responses from the denominator and from the total sum. I currently have 1 cell for this operation - which doesn't work when the response is N/A since it's a simple (sum)/7 equation. Thanks for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing all numeric values only in cells in a column | Excel Worksheet Functions | |||
| averages for cells | Excel Worksheet Functions | |||
| Summing first 2 characters of a cell (some non-numeric) | Excel Discussion (Misc queries) | |||
| Replacing characters in numeric text strings and SUMming | Excel Discussion (Misc queries) | |||
| Summing part of an Alpha Numeric String | Excel Worksheet Functions | |||
Threaded Mode
