simple code for MS Excel 3

[sidalam]

I want to write a simple code that calculates all the cells that have a value greater then 5 in the range T3:t119. What am I doing wrong?

=countif(T3:T119, <5)

 

[GlennUK]

Put the condition inside quotes.

=COUNTIF(T3:T119,">5")

( Note that I used Greater Than rather than Less Than which you gave in your example )

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[sidalam]

Thank you GlenUK this has been great help.

I have a new question.

I want to write a simple code that calculates all the cells that have a value less then 5 in the range T3:t119 BUT NOT COUNT ANY VALUE THAT HAS A CELL VALUE 0.

HERE IS THE CODE SO FAR

=COUNTIF(T3:T119, "<=5")

 

[SkipVought]

hi,
[tt]
=COUNTIF(T3:T119, "<=5") - COUNTIF(T3:T119, "0")

[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}