sumif help.

J

Jambruins

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
 
F

Fredrik Wahlgren

Jambruins said:
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
Click to expand...


You can use something like

=SUMIF(J2:J81,"<99999999999")

/Fredrik
 
D

Dave Peterson

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.
 
Top