Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to avergage colums
Is there a easier way to average a column that appears in many sheets in a woorkbook.
I know how to running average columns, but I have like 15 or so of these (new one every month) here is what I use now. where row 1 is a header so we start with row 2 and then the row enght is number ofd days in a month. =AVERAGE(Jan!$C$24:Jan!$C$54,Feb!$C$2:Feb!$C$30,Ma r!$C$2:Mar!$C$32,Apr!$C$2:Apr!$C$31,May!$C31:May!$ C$32,Jun!$C$2:Jun!$C$31,Jul!$C$2:Jul!$C$32,Aug!$C$ 2:Aug!$C$32,Sep!$C$2:Sep!$C$31,Oct!$C$2:Oct!$C$32, Nov!$C$2:Nov!$C$31,Dec!$C$2:Dec!$C$32,Jan13!$C$2:J an13!$C$32,Feb13!$C$2:Feb13!$C$29,Mar13!$C$2:Mar13 !$C$32,Apr13!$C$2:Apr13!$C2) then it would be $c3 then $c4.... to end of the month Thanks in advance for any help :-) Last edited by Milo Bloom : April 5th 13 at 07:00 AM Reason: easier to understand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze first colums and hide one colums | Excel Worksheet Functions | |||
Help with colums | Excel Programming | |||
Combine Two Colums | New Users to Excel | |||
Colums | Charts and Charting in Excel | |||
Sum YTD Colums | Excel Discussion (Misc queries) |