| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sum Of Cells in a Column
How can I get the sum of data in a column if there are non number
elements too? FOr example, I have got a column with numbers and #NA. When I take the sum or average, #NA is diplayed. Instead I want to get the actual average of numbers alone. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Add cells in column depending on value of cells in another column | Excel Discussion (Misc queries) | |||
| how do I update a column and create new rows for new column cells | Excel Discussion (Misc queries) | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Threaded Mode
