find average of values from multiple sheets?

  • Thread starter Thread starter Shadab Malik
  • Start date Start date
S

Shadab Malik

how can i find average of values to a field present in 10 different sheets of
the same workbook. the fields may or may not be located in the same cell
position, so a lookup before average is necessary.

thanks in advance for all help.
 
To do an average of cells on 10 different sheets, use something like:
=(sheet1!a2+sheet2!a5+sheet3!d7+...+sheet10!d87)/10

It's unclear what you mean by "a lookup before average is necessary". If you
need more help, post back.

Regards,
Fred.
 
Back
Top