| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of different cells ignoring blanks
On Wednesday, 16 May 2018 03:44:23 UTC+12, Craig Pyle wrote:
Hi I am struggling to get averages of multiple cells on a sheet (not in a range) whilst ignoring blank cells. Can anyone assist please? Excel is not very friendly when you start splitting your data into multiple tables. I would make a "Totals" sheets where I collect the sums and counts from each sheet. You can then calculate the overall averages from these. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Average of an Array of Data for numbers less than 22, while ignoring blanks | Excel Discussion (Misc queries) | |||
| ignoring blanks cells while importing data | Excel Programming | |||
| Criteria average ignoring blanks | Excel Discussion (Misc queries) | |||
| Criteria average ignoring blanks | Excel Discussion (Misc queries) | |||
| Conditional Average Ignoring Blanks | Excel Worksheet Functions | |||
Threaded Mode
