D
deskmac
I am struggling to find an answer to my dilemma.
I have a workbook with dates of the month, 1-31, then a summary sheet wherein I would like to calculate averages for certain parameters. I can set-up the formulas for sheet 1 but how do I "copy" this formula for sheet 2. WhenI drag/copy&paste I find that the formula still refers to sheet 1 and not sheet 2. I know how to inform excel that I want it to keep the same cells with the "$" sign but how do I inform it to give me the average for sheet 2 and not sheet 1?
Any help is highly appreciated.
Cheers,
James
I have a workbook with dates of the month, 1-31, then a summary sheet wherein I would like to calculate averages for certain parameters. I can set-up the formulas for sheet 1 but how do I "copy" this formula for sheet 2. WhenI drag/copy&paste I find that the formula still refers to sheet 1 and not sheet 2. I know how to inform excel that I want it to keep the same cells with the "$" sign but how do I inform it to give me the average for sheet 2 and not sheet 1?
Any help is highly appreciated.
Cheers,
James