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

"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

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