M

#### Milo Bloom

a woorkbook.

I know how to average a column, but I have like 15 or so of these (ne

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 i

number ofd days in a month.

=AVERAGE(Jan!$C$24:Jan!$C$54,Feb!$C$2:Feb!$C$30,Mar!$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$2ec!$C$32,Jan13!$C$2:Jan13!$C$32,Feb13!$C$2:Feb13!$C$29,Mar13!$C$2:Mar13!$C$32,Apr13!$C$2:Apr13!$C31)

Thanks in advance for any help :-