I don't think it's the formula but here it is: =SUM('Randall Sec'!C5)

"CLR" wrote:

Post your formula.........chances are that you have some ABSOLUTE references
therein,, (the $ sign)

Vaya con Dios,
Chuck, CABGx3



"Lori" wrote:

I need to copy a formula to worksheet 1 from worksheet 2 - the formula needs
to fill by column and I can only get it to fill a series by row - does anyone
know how to change so the formula will fill across my row in worksheet 1 by
the answer going down the column from worksheet 2?