fill formula to next row

[sk1325]

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)

please advise

[#2]

Hi,

You have to make the criteria range absolute (Locked) by preceding the row and column references by the dollar sign as follows:

=COUNTIF($A$2:$R$155,B2)

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

[#3]

wow!
it worked.

thanks