AverageIF with non consecutive columns

markkrebs

trying to do =AVERAGEIF([Jan 2020-SUM-Actual $]@row:[Dec 2020-SUM-Actual $]@row, @cell > 0)

Works awesome unless I move a column into the range set. Anywork around so it's independent of column position? I know I could do a big complex If statement but was trying not make it simple.

Ramzi K

@markkrebs

One idea if you have to move columns into the range

Create another range of columns where cell values equal those of the JAN-DEC range, hide it, and average that on.

However, the short answer to your question is no. Once you move something into the range it gets included.

Ramzi K

@markkrebs

One idea if you have to move columns into the range

Create another range of columns where cell values equal those of the JAN-DEC range, hide it, and average that on.

However, the short answer to your question is no. Once you move something into the range it gets included.