Forum Discussion
Solved
Average of nonsequential range if adjacent values meet some criteria...
Hi 🙂 I am trying to construct a formula that will allow me to find the average of a nonsequential range of values, given the value in the cell to their immediate left is 1 and not 2 (where 1 rep...
Press the Ctrl + Shift + Enter keys simultaneously
=AVERAGE(IF(A2:H2=1,OFFSET(A2:H2,0,1),""))
...
As variant
=SUMPRODUCT(ISODD(COLUMN(A2:G2))*(A2:G2=1)*B2:H2) / SUMPRODUCT(ISODD(COLUMN(A2:G2))*(A2:G2=1))