View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default excel average function

If the 3 target cells have same address (within their respective sheet) AND
sheets are contiguous, you can use:
=AVERAGE(Sheet1:Sheet3!A1)

Cheers
--
AP
"twometer" a écrit dans le message de
news: ...
How do you use the average function across 3 or more spreedsheets?