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