| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing cells that have VALUE errors in them
I need some assistance in doing a SUM function. The cells I am trying to SUM
may have an #VALUE error in them. How do I get the SUM to not include those cells? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing cells that have VALUE errors in them
Try this:
=SUMIF(A1:A10,"<#VALUE!") Biff "NewKid" wrote in message ... I need some assistance in doing a SUM function. The cells I am trying to SUM may have an #VALUE error in them. How do I get the SUM to not include those cells? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing cells that have VALUE errors in them
Thanks much!
"T. Valko" wrote: Try this: =SUMIF(A1:A10,"<#VALUE!") Biff "NewKid" wrote in message ... I need some assistance in doing a SUM function. The cells I am trying to SUM may have an #VALUE error in them. How do I get the SUM to not include those cells? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing cells that have VALUE errors in them
You're welcome. Thanks for the feedback!
Biff "NewKid" wrote in message ... Thanks much! "T. Valko" wrote: Try this: =SUMIF(A1:A10,"<#VALUE!") Biff "NewKid" wrote in message ... I need some assistance in doing a SUM function. The cells I am trying to SUM may have an #VALUE error in them. How do I get the SUM to not include those cells? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells with numbers and ignore cells with errors | Excel Discussion (Misc queries) | |||
| Sum some cells in column but not #n/a errors | Excel Discussion (Misc queries) | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
| Summing a Column wit errors? | Excel Worksheet Functions | |||
Hybrid Mode
