How can i count a range of cells ??

[toyo2]

I try CountIF(g4:g229,And(">100","<220") this on dont work help plz

 

[Jonmo1]

Welcome to the board.

Which version of XL do you have?
If you have XL2007+ you can use COUNTIFS

=COUNTIFS(Q4:Q229,">100",Q4:Q229,"<220")


In XL2003 or earlier, you need sumproduct

=SUMPRODUCT(--(Q4:Q229>100),--(Q4:Q229<220))

 

[vds1]

=countifs(g4:g229,">100",g4:g229,"<220")

 

[Rick Rothstein]

Maybe this (not 100% sure whether you need < or <= for either COUNTIF function call... it depends if you need to count or exclude the boundary numbers... your post shows you excluding them so that is what I set up my formula to do...

=COUNTIF(G4:G229,"<200")-COUNTIF(G4:G229,"<=100")

 

[toyo2]

Thank you all good people

 

[Jonmo1]

You're welcome.

 

[Aladin Akyurek]

I try CountIF(g4:g229,And(">100","<220") this on dont work help plz

If you don't have CountIfs...

=COUNTIF(G4:G229,">100")-COUNTIF(G4:G229,">=220")