User Profile
kelahw
Copper Contributor
Joined Dec 04, 2019
User Widgets
Recent Discussions
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 COUNTIF function for each code I am trying to count. But, when I try to continue the pattern and use autofill (i.e. a set range of boxes and criteria matching a column of codes), the equation changes range and will not retain the original range I specified. What gives! Does anyone know how to fix this? Thanks! Cheers, ~Kela HW13KViews0likes3Comments
Recent Blog Articles
No content to show