R
Rubix
I would like to average column C7 to C37 but would like to exclude
cells with just zeros in them.
Ex. AVERAGE(C7:C37)
Each cell from C7 to C37 has a Paste Link to it from another worksheet
so zeros appear in all the cells that have not yet been entered.
I get an incorrect average because its dividing by 31 rather than
cells numbers otherr than zero that have been entered.
Thanks,
Rube
cells with just zeros in them.
Ex. AVERAGE(C7:C37)
Each cell from C7 to C37 has a Paste Link to it from another worksheet
so zeros appear in all the cells that have not yet been entered.
I get an incorrect average because its dividing by 31 rather than
cells numbers otherr than zero that have been entered.
Thanks,
Rube