COUNTIF criteria

[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,

 

[Viggo]

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.

 

[Viggo]

Thanx a lot - works perfectly!

-----Original Message-----
If you want to add the criteria in the formula, try using
this:

=COUNTIF(MySource,"<"&D4)

Ecco

.