Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif help.
I have a formula in cells J2:J81. The formula returns a number or a #NUM!
message. How do I sum all the cells that contain a number? The #NUM! will be replaced with a number eventually so I want to the sum to update as the numbers replace the #NUM!. Thanks |
#2
|
|||
|
|||
"Jambruins" wrote in message ... I have a formula in cells J2:J81. The formula returns a number or a #NUM! message. How do I sum all the cells that contain a number? The #NUM! will be replaced with a number eventually so I want to the sum to update as the numbers replace the #NUM!. Thanks You can use something like =SUMIF(J2:J81,"<99999999999") /Fredrik |
#3
|
|||
|
|||
One way:
=SUM(IF(ISNUMBER(j2:j81),j2:j81)) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) You can expand/contract your range--but don't use the whole column. Jambruins wrote: I have a formula in cells J2:J81. The formula returns a number or a #NUM! message. How do I sum all the cells that contain a number? The #NUM! will be replaced with a number eventually so I want to the sum to update as the numbers replace the #NUM!. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF Not | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |