I have a financial report workbook with 1 spreadsheet per month. I have a
"Year end" sheet with categories into which I want to total a range of cells
from each month's sheet. I have used this formula:
=SUM(January!C32:C36+February!C32:C36+March!C32:C3 6+April!C32:C36+May!C32:C3
6+June!C32:C36+July!C32:C36+August!C32:C36+Septemb er!C32:C36+October!C32:C36
+November!C32:C36+December!C32:C36) for all"total" cells on the Year End
sheet, but it won't work for only one of them. Instead, it returns a
"#value". If I change the formula to only add the range of cells in 1
sheet, it works fine. Once I add a second sheet, the error returns.

I have double-checked the formats of all involved cells. All of them are
set to currency with 2 decimals, a $ and (-1234.56) for negative numbers.
(ALL cells containing dollar amounts are fomatting this way.)

I have tried everything I can think of! I've tried to use the evaluation
tool and the very first month (January!) shows the #value error. I have
tried omitting January!, but the error then starts with February! and so on.

I apologize for the "long story", but am trying to make this as clear as
possible. Any help would be GREATLY appreciated. I've spent too many days
on this!

Thanks

Nancy