My formula will go in cell B16068 (and will be dragged down to subsequent cells). It will look for the value in $A16068 in the range $A$3:$A$16063
I’m starting with this =AVERAGEIFS($A16068,$A$3:$A$16063, and that's where I get stuck.
From there I need it to look in $E$3:$P$16063 where the value of the cell is greater than 0.
For every row A3:A16063 where the value in A16068 is found, look in E3:P16063, if the value is greater than 0, add them up and divide by how many there are to give me the average.
Thanks in advance.
I’m starting with this =AVERAGEIFS($A16068,$A$3:$A$16063, and that's where I get stuck.
From there I need it to look in $E$3:$P$16063 where the value of the cell is greater than 0.
For every row A3:A16063 where the value in A16068 is found, look in E3:P16063, if the value is greater than 0, add them up and divide by how many there are to give me the average.
Thanks in advance.