Problem with my sum offset function

[lbrydie]

I recently shamelessly borrowed a workbook template that uses the SUM OFFSET function to calculate a range of numbers. The formula works fine in one workbook but doesn't calculate correctly in another. I copied the formula from the workbook that is functioning propertly and it still doesn't work. Here is the formula: SUM(OFFSET(N30,-1,,MATCH("Balance Per General Ledger",I$1:I$105,0)-ROW())). Can anyone point me in the right direction to correct the error...

I can share the workbooks if necessary.

Linda B.

 

[StephenCrump]

Welcome to the Forum!

As written, your formula is going to calculate SUM(N29:Nxx) where xx is some row value.

Is this what you intended?

And if so, how do you want xx to be determined?