Count Cell Range

[discgolfer_1999]

I am having problems figuring out a Count command within a certain
range.

This is what I am looking for

If Cells D120 are less than Cell B2, Count the total cells that are
less than B2

I know this is probably easy, but i just font get it

Thanks again

 

[Biff]

Hi!

Try this:

=COUNTIF(D120,"<"&B2)

Biff

"discgolfer_1999"

 

[Zack Barresse]

What if they are more than B2?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"discgolfer_1999"