Forum Discussion

Copper Contributor

Dec 04, 2019

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...

excel

Formulas and Functions

ChrisMendoza

Iron Contributor

Dec 04, 2019

kelahw -

Are you trying to do something similar to what was posted at https://techcommunity.microsoft.com/t5/Excel/Conditional-Formatting-highlighting-cells-using-IF-formula/m-p/1046518?

This will count the occurrence of the initials in the range:

=COUNTIF($B$11:$J$23,$B$3:$B$8)

kelahw
Copper Contributor
Dec 04, 2019
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
  Iron Contributor
  Dec 04, 2019
  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.