countif in excel

December 22, 2009 at 02:26:35
Specs: Windows XP
i want to know how can i use countif in excel to count the number of cells between two values
like :
i want to know how many numbers between 50 to 60(>=50 & <60)

See More: countif in excel

Report •

December 22, 2009 at 05:16:48

With your data in cells A1 to L1
Enter 50 in A2 and 60 in A3
Enter this in cell A4:


The result was 6


Report •

December 22, 2009 at 05:51:43
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.

Report •

Related Solutions

Ask Question