Excel Guides

Averaging a Non-Contiguous Range in Excel

To average a non-contiguous range in Excel, you can use the SUMPRODUCT function. This function multiplies ranges or arrays together and returns the sum of those products.

For example, to average cells A1:A5 and C1:C5, you can use the following formula:

=SUMPRODUCT(A1:A5,C1:C5)/SUM(A1:A5)

You can also use the AVERAGE function to average a non-contiguous range. This function simply calculates the arithmetic mean of a given set of values.

For example, to average cells A1:A5 and C1:C5, you can use the following formula:

=AVERAGE(A1:A5,C1:C5)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.