Taking the #NUM! out of the sum

Status
Not open for further replies.

=HPSF=RMP

Board Regular
Joined
Jun 9, 2004
Messages
188
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,497
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,251
Members
412,709
Latest member
Rishu
Top