COUNTIF criteria

  • Thread starter Thread starter Viggo
  • Start date Start date
V

Viggo

Hi,
I have some large data tables and want to make COUNTIF
formulas to return the number of datapoints above, below
etc certain values. I would like to make the
formula "interactive" so I dont have to create a new
formula for each criteria. I would like to enter the value
in a certain cell which is then used as criteria in the
formula.
Does anybody know how to do that ?

Thanx,
 
Thanx,
but this doesn't work when I want to add >,< or = in front
of the cell reference. (I guess only the value from the
cell should be retrieved).
Is there a fix for this ?

Thanx again.
 
Back
Top