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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,261
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.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,624
Messages
5,832,743
Members
430,160
Latest member
a_majda

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top