Good Evening and Thank you in advance for any help.
I am trying to copy a formula in 1000 rows, without it changing, yet keeping the reference number the same.
ex.
=COUNTIF(MON!C10:C70,KEY!E3)
* *=C10:C70 NEEDS TO REMAIN THE SAME
while E3 counts up E4, E5, E6 etc, to E1000
=COUNTIF(MON!C10:C70,KEY!E4)
=COUNTIF(MON!C10:C70,KEY!E5)
=COUNTIF(MON!C10:C70,KEY!E6)
=COUNTIF(MON!C10:C70,KEY!E7)
When I copy and paste from he first cell it ends up counting the formula also.
=COUNTIF(MON!C11:C71,KEY!E4)
=COUNTIF(MON!C12:C72,KEY!E5)
=COUNTIF(MON!C13:C73,KEY!E6)
etc etc
HOW do I keep the formula from changing while having the reference number count up??
Thank you for any help!
Bookmarks