Adding Values in cells while ignoring errors

Question

Hello, 

I would like to add a number of different cells together from several tables I have on my spread sheet. The Tables are all different and I only want certain data from each table to be added up. When I add up the total in cell E12 and the total in cell E25, is it possible to ignore the #VALUE! error in the second table (Cell E25) and for the total to read '10'? 

I want to be able to use this as a template, so I don't really want to have to add up each item individually. 

Any info would be appreciated. 

Thanks,

Answer 1

Couple of options:

This returns the sum of E10 & E25 and skips all errors in these cells:

=AGGREGATE(9,6,E10,E25)

This returns the SUM of E8:E30 where B8:B30 = "Exp" and specifically skips the #VALUE! error:

=SUMIFS(E8:E30,B8:B30,"Exp",E8:E30,"<>#VALUE!")

This returns the SUM of E8:E30 where B8:B30 = "Exp" and E8:E30 > 0, and skips all errors:

=SUMIFS(E8:E30,B8:B30,"Exp",E8:E30,">0")

Regards,

Amit Tandon

www.globaliconnect.com

Answer 2

Hi,

Try this

=SUMIFS(E8:E30,B8:B30,"Exp",E8:E30,"<=1E100")

Hope this helps.

Answer 3

You can use the below formula

=IFERROR(E12,0)+IFERROR(E25,0)