| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averages formula for multiple ranges
What is the correct formula if I want to find the average for numbers that
are in multiple ranges and I don't want to count empty cells in those multiple ranges? For example: my numbers are in ranges A4:A11 and A16:A23 and A30:A44. Keep in mind that some of the cells in those ranges are empty so I don't want to count them. Thanx in advance for your help... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Averages formula for multiple ranges
Try this:
=AVERAGE(A4:A11,A16:A23,A30:A44) "Raytown" wrote: What is the correct formula if I want to find the average for numbers that are in multiple ranges and I don't want to count empty cells in those multiple ranges? For example: my numbers are in ranges A4:A11 and A16:A23 and A30:A44. Keep in mind that some of the cells in those ranges are empty so I don't want to count them. Thanx in advance for your help... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Averages formula for multiple ranges
The AVERAGE() function ignores empty cells
In article , Raytown wrote: What is the correct formula if I want to find the average for numbers that are in multiple ranges and I don't want to count empty cells in those multiple ranges? For example: my numbers are in ranges A4:A11 and A16:A23 and A30:A44. Keep in mind that some of the cells in those ranges are empty so I don't want to count them. Thanx in advance for your help... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named ranges in multiple criteria formula | Excel Discussion (Misc queries) | |||
| Most efficient formula/combining multiple data cell ranges/seperat | New Users to Excel | |||
| formula using multiple ranges | Excel Discussion (Misc queries) | |||
| How to obtain Averages from a list of multiple items? | Excel Discussion (Misc queries) | |||
| select multiple cell ranges in "sumif" formula? | Excel Worksheet Functions | |||
Linear Mode
