Need your help please. I have a sheet with 2 tabs. I have an average function in the second tab as below.
=AVERAGE('Ad Hoc'!HO5:HU5)+AVERAGE('Ad Hoc'!HO6:HU6)+AVERAGE('Ad Hoc'!HO7:HU7)
When I drag the same formula to the next Colum, I want the cell to count 7 columns after HO5:HU5 (Which should be HV5:IB5) but when I drag the formula across it gives me HP5:HV5. Is there anyway to fix it, so it counts 7 columns after the last Colum HU5?
Thanks for all your help.
=AVERAGE('Ad Hoc'!HO5:HU5)+AVERAGE('Ad Hoc'!HO6:HU6)+AVERAGE('Ad Hoc'!HO7:HU7)
When I drag the same formula to the next Colum, I want the cell to count 7 columns after HO5:HU5 (Which should be HV5:IB5) but when I drag the formula across it gives me HP5:HV5. Is there anyway to fix it, so it counts 7 columns after the last Colum HU5?
Thanks for all your help.