Hi Colin,

Press Ctrl + H, and replace N2928:N3657 with N3660:N4208. Again replace
P2928:P3657 with N3660:N4208. Just two simple steps are you are done.
Thanks.

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"colin" wrote:

Hi
I have the following formulas in cells A1 and A2

=COUNTIF(Log!N2928:N3657,"4")/2
=COUNTIF(Log!P2928:P3657,"4")/2

Is there an easy way to amend the formulas to:

=COUNTIF(Log!N3660:N4208,"4")/2
=COUNTIF(Log!P3660:P4208,"4")/2

without having to manually typing them in (please note that I need to
maintain the column references)

Many thanks in anticipation

Colin