countif

  • Thread starter Thread starter antoniodias
  • Start date Start date
A

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
 
=COUNTIF(A2:A10,">=30")-COUNTIF(A2:A10,">40")

or

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