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?
|