Thread: Average Cells in Multiple Worksheets
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Average Cells in Multiple Worksheets
=AVERAGE(Sheet1:Sheet4!A1)


"Karen" wrote:

I am trying to average cells in multiple worksheets.
Let's say that in:
Sheet1 Cell A1 = 4.40%
Sheet2 Cell A1 = 2.65%
Sheet3 Cell A1 = 3.61%
Sheet4 Cell A1 = 1.59%

What would be the formula to average these percentages?

Thank you, Karen


Reply With QuoteReply With Quote