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