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