i'm trying to copy this formula =COUNTIF(A2:R155,B2) to the next row and fill the it to =COUNTIF(A2:R155,B3). what happens when i drag the box =COUNTIF(A3:R156,B2) . if i copy the formula and paste i get=COUNTIF(A2:R155,B2)
You have to make the criteria range absolute (Locked) by preceding the row and column references by the dollar sign as follows:
This will prevent the range from changing when copying the formula down.
To learn more about that, please check out this link.
Hope that helps