i want to know how can i use countif in excel to count the number of cells between two values

like :

50,32,14,55,60,70,80,55,54,52,51,87

i want to know how many numbers between 50 to 60(>=50 & <60)

Hi, With your data in cells A1 to L1

Enter 50 in A2 and 60 in A3

Enter this in cell A4:=SUMPRODUCT((A1:L1>=A2)*(A1:L1<A3))The result was 6

Regards

This formula presents a great opportunity to see the inner workings of Excel in general, and the SUMPRODUCT function specifically. Select A4 and click on Tools...Formula Auditing...Evaluate Formula.

Click the Evaluate button to see how Excel deals with the formula, piece by piece.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History