Sum formula using cells in multiple sheets

[pj]

I have a YTD formula that I need to sum up the values of the same cell in 12
different sheets. When I use the formula Janec!116 or even put it in
Jan!116, Feb!116, etc, it gives me a value of zero.

The cells i'm referencing already have a formula inside. Do I have to use
the value of the formula, or do i have to input the actual formula to get my
result?

 

[John C]

What is your column reference? You have a row, but now column:
=SUM(Sheet1:Sheet2!A116)

 

[pj]

I figured it out...one of the cells had an error that was messing up the
whole formula. Thanks!

 

[John C]

Huh, if I sum range that includes a cell that evaluate to an error, I don't
get 0, I get an error. Huh.