Averages formula for multiple ranges

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging two ranges on the same column (excluding zeros) 2
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Dependent drop down dynamic range formula, off sheet. 7
Autofill only copying initial value, not filling formula 2
Excel 2 into 1 6
Another which count function? 7
How to get range names to Apply across multiple tabs 1
Need to Count Occurences in Multiple Ranges 3

Top