S
Soz
Can you use a cell reference as the criteria in the countif formula.
I was looking for something that would count the cells and give me everthing
less than < a number from another cell.
I can use =countif(A1:A20,"<63.1") with the 63.1 value being an average
number taken from a cell (C21) that periodically changes. I can use the cell
number =countif(A1:A20,C21) but that would only count the cells that have
the one value. I was looking for something like
=countif(A1:A20,"<$C$21"). Can anybody set me straight I'm not real good at
this.
I was looking for something that would count the cells and give me everthing
less than < a number from another cell.
I can use =countif(A1:A20,"<63.1") with the 63.1 value being an average
number taken from a cell (C21) that periodically changes. I can use the cell
number =countif(A1:A20,C21) but that would only count the cells that have
the one value. I was looking for something like
=countif(A1:A20,"<$C$21"). Can anybody set me straight I'm not real good at
this.