formula count +1 to each cell when dragged

[JonathanVR]

hi there, im currently using:
=IF(COUNTIF(Teams!B7:B17,A5),Teams!B5,"")&" "&IF(COUNTIF(Teams!C7:C17,A5),Teams!C5,"")

starting at A5, when i drag the formula down the column it +1 to each cell e.g
=IF(COUNTIF(Teams!B8:B18,A6),Teams!B6,"")&" "&IF(COUNTIF(Teams!C8:C18,A6),Teams!C6,"")


why is this? i want to drag the formula, keep it the same and all that must change is the A5-A6 because thats where the formule is going.

Thank you / Kind Regards
Jonathan Van Rooyen

[twiggywales]

try this

Please Login or Register  to view this content.

putting $ infront of a column or row referance locks it so when you drag it wont alter

[JonathanVR]

+rep, Thanks