can't resolve formula keeps coming up with #Name?

=(EDESIX041F_WiFi_BOM!$S$1*'Common Parts Required'!F2)+(EDESIX041H_WiFi_BOM*'Common Parts Required'!G2)+(EDESIX052D1-S_BOM*'Common Parts Required'!H2)+(EDESIX041H_WiFi_BOM!$S$1*'Common Parts Required'!I2)+('EDESIX052D1-S_BOM'!$S$1*'Common Parts Required'!J2)+('EDESIX052D1-U_BOM'!$S$1*'Common Parts Required'!K2)+(#REF!*'Common Parts Required'!L2)+(EDESIX046B2_BOM!$S$1*'Common Parts Required'!M2)+(EDESIX047B_BOM!$S$1*'Common Parts Required'!N2)+(EDESIX051A1_BOM!$S$1*'Common Parts Required'!O2)+(EDESIX048C1_BOM!$S$1*'Common Parts Required'!P2)+(EDESIX043A1_BOM!$S$1*'Common Parts Required'!Q2)+(EDESIX012EXL_BOM!$S$1*'Common Parts Required'!R2)+(EDESIX055B_BOM!$S$1*'Common Parts Required'!S2)+(EDESIX007D7_BOM!$S$1*'Common Parts Required'!T2)+('EDESIX057C-S_BOM'!$S$1*'Common Parts Required'!U2)+('EDESIX056C-L_BOM'!$S$1*'Common Parts Required'!V2)

your formula is very long, do you have any named ranges?
EDESIX041F_WiFi_BOM!$S$1 refrences a cell
EDESIX041H_WiFi_BOM references nothing!

you appear to do this several times in your formula, I would start there

Originally Posted by davsth

EDESIX041H_WiFi_BOM references nothing!

Depends if that's a named range.

There's also a #REF! error in the formula.

EDESIX041H_WiFi_BOM references nothing!

these are taken from the individual pages that make up the calculation
Capture 1.PNG

That shows #REF! errors, not #NAME? errors.