Sum with Errors

dgoodrid · #1 05-23-2006, 01:19 PM

All,

can someone help me please. can someone advise me how to add the following information up.

I need to ADD the numbers listed below but if a cell value = #N/A then the result = #N/A

Example 1
----------

2 4 4 "=sum(A1:A3)" - 10

2 #N/A 4 "=sum(A1:A3)" - #N/A

Any advise, I cant stop the errors in the cells as they are looking for info in a Vlookup table and there is no data found.

Dave

sven137 · #2 09-12-2006, 02:30 AM

I too am looking for a solution. We need something in the formula to tell it to ignore non-numerical or ISERROR value. Something about If(AND(ISNUMBER.... but that is as far as I've got.

sven

sven137 · #3 09-12-2006, 11:02 PM

Hi, I found a solution to ignore the error fields so that the sum function works.

My sum total is in column 3 & my lookup values are in column 2.
=IF(ISERROR(C2),0,C2)

This is stating that if the cell ISERORR due to being blank or value error in the lookup then fill field with 0, if the field is not blank then use the value found in the cell. I hope this helps you.

cheers
Sven

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)