I have 12 cells (say a1 to a12) all with values in them. I want to get the average of the cells but only from jan to sep as that is where we are now. Each month the range changes to where we are.
If I use =AVERAGE and range it through the 12 cells, it will give me an average on all twelve, even though oct to dec has zero.
I cannot remove the zero as there is a cell reference in it.
Any ideas
Thanks
Neil
ps. hope this makes sense.
If I use =AVERAGE and range it through the 12 cells, it will give me an average on all twelve, even though oct to dec has zero.
I cannot remove the zero as there is a cell reference in it.
Any ideas
Thanks
Neil
ps. hope this makes sense.