Taking the #NUM! out of the sum

[=HPSF=RMP]

ColumnB is a list of times. ColumnC is True if the gap of time in ColumnB is greater than 10 Minutes. ColumnD will show that time gap greater than 10 Minutes and have no results for anything under 10 minutes.

The problem I have is I want to format the cells all the way down the column and protect it allowing the user to paste the activity time in. If you notice there is the #NUM! located in column D which wont allow me to SUM the whole Column D. It returns #NUM!. Is there a way to ONLY sum the actual numbers and ignore the #NUM!? I hope I explained this correctly.

thanks again



B C D
Activity_Time ID Gap
11/21/2005 19:20 TRUE 0:35:00
11/21/2005 19:55 FALSE 0:00:00
11/21/2005 19:56 FALSE 0:00:00
11/21/2005 19:56 FALSE 0:00:00
11/21/2005 19:58 #NUM! #NUM!
FALSE 0:00:00
FALSE 0:00:00

 

[Andrew Poulsom]

Rather than starting a new thread, why don't you answer my question here?

http://www.mrexcel.com/board2/viewtopic.php?p=869323&highlight=#869323

 

[Joe4]

Usually the best method is to fix what is causing the #NUM error. Is it a formula that is returning this #NUM error?

If so, post it here, and we may be able to help you fix it so that it will not return this error.

 

[starl]

Original Question: http://www.mrexcel.com/board2/viewtopic.php?t=180776