Thread: Average of multiple cells across multiple sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Simon Woodward Simon Woodward is offline
external usenet poster
  
Posts: 6
Default Average of multiple cells across multiple sheets
On Wednesday, 16 May 2018 03:45:58 UTC+12, 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?

I would suggest collecting all the values into a single sheet first. Then you can use SUM(cells)/COUNT(cells) to ginore blanks.
Reply With QuoteReply With Quote