#VALUE! Error

[atomlins]

Hi!

I am trying to use this formula:
=SUM('S:\GeoTility\STAFF TIME SHEETS\Time Logs\[December 2007.xls]Total'!B256:B257)+('[January 2008.xls]Total'!$B$256:$B$257)

And no matter how I try and referance the other total sheet, it comes up #VALUE! ......

Can anyone help me?!

Thanks so much.....
Amy

[solnajeff]

Hi

The problem is that you are trying to add two ranges and place the result into a single cell. You can add single values but not ranges with the + operand.

If for example you wish to add B256 to B256 on the second sheet and B257 to B257 on the second sheet then you would need two formulas one in each cell to achieve it.

Regards

Jeff

[mikerickson]

=SUM('[December 2007.xls]Total'!B256:B257 , '[January 2008.xls]Total'!$B$256:$B$257)

SUM will work on discountious ranges even across workbooks. A comma is the separater for SUM
The workbooks need to be open.

[atomlins]

Thank you!

I didn't understand why -- now I do!

Thanks so much for your help!

Cheers,

Amy