Forum Discussion
How to calculate averages of different, non-overlapping cell ranges in Excel using a single formula
Hello dear experts! This is Vikas Dixit from India. I wish to calculate averages of different non-overlapping cell ranges in Excel using a single formula, is it possible anyway? To elaborate it furth...
Calculate the average of a group of numbers
Calculate the average of numbers not in a contiguous row or column
To do this task, use the AVERAGE function. Copy the table below to a blank worksheet.
Formula | Description (Result) |
=AVERAGE(A2:A7) | Averages all of numbers in list above (9.5) |
=AVERAGE(A2:A4,A7) | Averages the top three and the last number in the list (7.5) |
=AVERAGEIF(A2:A7, "<>0") | Averages the numbers in the list except those that contain zero, such as cell A6 (11.4) |