Locking formula for a Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an issue. I have this formula looking for numbers in a group:

I have two columns A and B
A1: "1"
A2: "2"
....
A10: "10"

B1: =COUNTIF(M3:R812,"01")
B2: =COUNTIF(M3:R812,"02")...
.... down to
B10: =COUNTIF(M3:R812,"10")

This gives me a large result which is what I want but then if I try to Sort
by Column B the formula will change to =COUNTIF(M13:R757,"01") <whatever it
may be>

I am looking to have it that the CountIf works but the formula will hold the
range of M3:R812 no matter what I sort by.
 
Back
Top