Averages formula for multiple ranges

[Raytown]

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...

 

[Barb Reinhardt]

Try this:

=AVERAGE(A4:A11,A16:A23,A30:A44)

 

[JE McGimpsey]

The AVERAGE() function ignores empty cells