View Single Post
  #1   Report Post  
Milo Bloom Milo Bloom is offline
Junior Member
 
Posts: 19
Default 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