"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