View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
iliace iliace is offline
external usenet poster
 
Posts: 229
Default Average of multiple cells across multiple sheets

On Tuesday, May 15, 2018 at 11:45:58 AM UTC-4, Craig Pyle wrote:
Hi

I am struggling to get averages of multiple cells across multiple sheets (not in a range) whilst ignoring blank cells.

Can anyone assist please?


For example, you can say:

=AVERAGE(Sheet1:Sheet4!A1)

This will average A1 in each of the sheets between Sheet1 and Sheet4. It is best if they are adjacent. If any cell is blank, AVERAGE() will ignore them.