Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Locking formula for a Sort
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. |
#2
|
|||
|
|||
Hi!
Use absolute references in your formulas: =COUNTIF($M$3:$R$812,"01") Biff -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Why does a formula change when I sort a column | Excel Worksheet Functions | |||
Calculating and locking the esult of a formula | Excel Discussion (Misc queries) |