average data from diff sheets

[shwethav]

need a quick formulae help from you in excel.





This is what am trying to do.



I have 2 sheets (A and B ) . From sheet B am taking the average of (A1:
B3) and want it in the A1 cell of sheet A. To put it concisely



sheet A



A1 Average (SheetB!(A1:B3))
B1 Average( SheetB!(C13))



A2 Average (SheetB!(A4:B6))
B2 Average( SheetB!(C46)) and so on.





sheet B has (60*48) cells



I want a common formulae or macro to do this but not sure how to go
about using offset or index functions for the same.



Will be helpful if you have some thoughts on this.

 

[Max]

sheet B has (60*48) cells

Assuming the source data is in a sheet: B, within A1:AV60
(note: the sheet's name is assumed to be simply only the letter: B)

Then, in sheet: A,

Put in A1:
=IF(COLUMN(A1)*2-2+65>90,AVERAGE(OFFSET(INDIRECT("'B'!A"&CHAR(COLUMN(A1)*2-2+39)&ROW(A1)*3-3+1),,,3,2)),AVERAGE(OFFSET(INDIRECT("'B'!"&CHAR(COLUMN(A1)*2-2+65)&ROW(A1)*3-3+1),,,3,2)))

Copy A1 across to X1, fill down to X60
A1:X60 will return the required results

need a quick formulae help from you in excel.
This is what am trying to do.
I have 2 sheets (A and B ) . From sheet B am taking the average of (A1:
B3) and want it in the A1 cell of sheet A. To put it concisely
sheet A
A1 Average (SheetB!(A1:B3))
B1 Average( SheetB!(C13))

A2 Average (SheetB!(A4:B6))
B2 Average( SheetB!(C46)) and so on.

sheet B has (60*48) cells