#VALUE! error

[cb123]

Hi there, hoping somebody can help me. If you can many thanks in advance

I have a sheet with different simple formula, such as multiplications and divisions etc and i am starting to sum all of the components together into 1 cell, lets call it A1. Below is A1 summing things up great for me

=SUM(L26+M40+M56+AW13+AT24)

Everything is going great in A1 until i try to include a cell in AT35 which has the below formula.

=IFERROR(VLOOKUP(AR35,Findings!$10:$15,MATCH('Blank Ecf P&S'!AS35,Findings!$2:$2,0),0)," ")

To remedy this i tried to add a =IFERROR(originalformula,"") to my sums in A1, this removes the #VALUE!! but also seems to negate all of the summing up which preceded it which i don't want

 

[RoryA]

There is no point to using both SUM and + there. If you use just SUM, it will ignore non-numeric values:

=SUM(L26,M40,M56,AW13,AT24,AT35)

 

[cb123]

Fantastic thanks so much!