Sum formula using cells in multiple sheets
 

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 Jan:Dec!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?

Sum formula using cells in multiple sheets
 

What is your column reference? You have a row, but now column:
=SUM(Sheet1:Sheet2!A116)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"pj" wrote:

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 Jan:Dec!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?

Sum formula using cells in multiple sheets
 

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

"John C" wrote:

What is your column reference? You have a row, but now column:
=SUM(Sheet1:Sheet2!A116)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"pj" wrote:

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 Jan:Dec!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?

Sum formula using cells in multiple sheets
 

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

"pj" wrote:

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

"John C" wrote:

What is your column reference? You have a row, but now column:
=SUM(Sheet1:Sheet2!A116)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"pj" wrote:

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 Jan:Dec!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?