| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. Can anyone assist please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find average of values from multiple sheets? | Excel Worksheet Functions | |||
| Define Name - same name for multiple cells on multiple sheets | Excel Worksheet Functions | |||
| Average same cell in multiple sheets | Excel Discussion (Misc queries) | |||
| Finding the average across multiple sheets | Excel Worksheet Functions | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
Hybrid Mode
