Forum Discussion
kelahw
Dec 04, 2019Copper Contributor
How to Set a Specified Range for COUNTIF Function when using Autofill
I am using the COUNTIF function to count specific codes within a specified range of rows/columns. While I understand how to do this separately for each code, I would like to be able to replicate this...
kelahw
Dec 04, 2019Copper Contributor
It was the exact issue!! I am realizing now that the absence of $ made a huge difference. Ugh wish I had caught that sooner. Thank you Chris!
ChrisMendoza
Dec 04, 2019Iron Contributor
kelahw -
Yeah, really understanding cell referencing takes awhile (at least for me). It's practically a must though when using Conditional Formatting like what that post needed.