| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum everything but errors
Nevermind; it works! wow; Thanks!
"Jeffrey" wrote: can I send you an example file? "Peo Sjoblom" wrote: Since I assume your error comes from a cell I replaced it with E4 but if you put #REF! in E4 you will see that this works =SUM(SUMIF(INDIRECT({"A1","C4","E4","D16:D22"}),"< =0"&999^99)) -- Regards, Peo Sjoblom "Jeffrey" wrote in message ... The range I need to sum can sometimes contain references to cells that have been deleted, creating a formula that looks like =SUM(A1,C4,#REF!,D16:D22) How can I get the formula to automatically disregard that specific error, and return the sum of the other cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #REF! errors | Excel Discussion (Misc queries) | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| #Value! errors | New Users to Excel | |||
| IIf and value-errors | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Threaded Mode
