| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sum the column with the error cells
I am trying to add the total for one column in which some cells have the
#REF! sign. My formula is: =SUMIF(Data!A1:Data!A100,"<#VALUE!") but the output is still #REF! and cannot display the value total. Does my formula miss any? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zero value cells/blank cells causing error in AVERAGE? | Excel Worksheet Functions | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Set RN = Range(Cells(2, 1), Cells(r, 1)) error | Charts and Charting in Excel | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| Column Chart Error Bar | Charts and Charting in Excel | |||
Threaded Mode
