average 4 data from different sheets
 

need a quick formulae help from you in excel.





This is what am trying to do.



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



Spreadsheet A



A1 Average (SheetB!(A1:B3))
B1 Average( SheetB!(C1:D3))



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





Spreadsheet 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.

average 4 data from different sheets
 

See response in worksheet.functions

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
oups.com...
need a quick formulae help from you in excel.





This is what am trying to do.



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



Spreadsheet A



A1 Average (SheetB!(A1:B3))
B1 Average( SheetB!(C1:D3))



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





Spreadsheet 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.