Remember Me?

#1
May 15th 18, 04:45 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2018 Posts: 3
Average of multiple cells across multiple sheets

Hi

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

#2
May 15th 18, 08:14 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2018 Posts: 6
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.

I would suggest collecting all the values into a single sheet first. Then you can use SUM(cells)/COUNT(cells) to ginore blanks.
#3
May 18th 18, 02:12 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2007 Posts: 228
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.

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Shadab Malik Excel Worksheet Functions 1 October 3rd 09 03:30 PM Thomas Excel Worksheet Functions 3 May 15th 09 10:48 PM Ellen G Excel Discussion (Misc queries) 8 June 23rd 08 10:17 PM quailhunter Excel Worksheet Functions 16 August 15th 06 12:13 AM quailhunter Excel Worksheet Functions 2 October 16th 05 10:37 PM

All times are GMT +1. The time now is 11:27 PM.