Good morning,
I am using average if =AVERAGEIF(AT177:AY177,"<>0"), to get the average of a series of data (similar to the one in the fist raw I have pasted here)
I am using if because I need to exclude the "0" from the calculation.
The complicated things for me now is that I need to divide each data by a number contained in a cell (shown here as 4), before getting the average (in this example is 2928)
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Any help is very much appreciate it.
Best regards,
Federico
I am using average if =AVERAGEIF(AT177:AY177,"<>0"), to get the average of a series of data (similar to the one in the fist raw I have pasted here)
I am using if because I need to exclude the "0" from the calculation.
The complicated things for me now is that I need to divide each data by a number contained in a cell (shown here as 4), before getting the average (in this example is 2928)
0 | 12,000 | 0 | 0 | 11,420 | 0 |
4 | |||||
2928 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Any help is very much appreciate it.
Best regards,
Federico