countif

[antoniodias]

Hello.

There is a tip to count how many numbers are in series of numbers whe
a certain criteria is set in Excel.

How can I change this tip for the case the criteria is the number
between 30 and 40, including 30 and 40?

Example: the numbers are 24,35,36,38,37,48,42, 40 and 30

The result: 6

Is this possible?

Thanks

 

[Peo Sjoblom]

=COUNTIF(A2:A10,">=30")-COUNTIF(A2:A10,">40")

or

=SUMPRODUCT(--(A2:A10>=30),--(A2:A10<=40))

 

[antoniodias]

thank you very much ;

 

[Gord Dibben]

antoniodias

=COUNTIF(H1:H9,">29")-COUNTIF(H1:H9,">40")

Gord Dibben XL2002