I am looking to sum two cells on different worksheets and it returns #VALUE!

Hello,

I am looking to sum two cells on different worksheets and it returns #VALUE!

The formula I have is: ='3c. Sales Fcast_Ortho + Helper'!C5+'4d. Sales Fcast_Spine Only'!C5

I have faced this problem before and solved it by modifying the formula as follows:
=SUMIF('3c. Sales Fcast_Ortho + Helper'!C5+'4d. Sales Fcast_Spine Only'!C5,">-9999999999",'3c. Sales Fcast_Ortho + Helper'!C5+'4d. Sales Fcast_Spine Only'!C5)

However, this has not worked. There are many linked cells, so this may be affecting it.

Does anybody have any ideas how to solve this? Have I written the SUMIF formula out correctly?

Any help much appreciated!

- A

Hi Adam-Do all of your cells contain NUMBERS?

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Try

=SUM('3c. Sales Fcast_Ortho + Helper'!C5, '4d. Sales Fcast_Spine Only'!C5)

Your original formula looks good, can you attach you workbook? (Click Go Advanced then scroll down to Manage Attachments)

or
=SUM('3c. Sales Fcast_Ortho + Helper':'4d. Sales Fcast_Spine Only'!C5)

Hi Jonmo1,

That works: =SUM('3c. Sales Fcast_Ortho + Helper'!C5, '4d. Sales Fcast_Spine Only'!C5)

Thanks all for your input. Much appreciated!

You're welcome.