countif function possibility?

  • Thread starter Thread starter shauntck
  • Start date Start date
S

shauntck

Hey guys, I'm trying to do a calculation that doesn't seem to be working
the way I want it to. I'm sure this is possible although I'm not sure
exactly how.

I need to do something like the following:

countif(e6:ab6; >ac6-ad6)

where basically i count all cells in a row that are greater than ac6 -
ad6...

Anyone know a good way to do that? it doesn't seem to like using the >
< symbols unless you know its a fixed value like ">5"

Any help would be greatly appreciated ... thank you so much.
-Shaunt
 
Hi Shauntck

You can put the greater-than symbol ( > ) in Cell C1 and use

=countif(e6:ab6;C1&ac6-ad6)

Then you could change that operator at will..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top