I need a solution to the problem below:
I've a table and in the first column titled 'VALUES' (A1) I've entered values ranging from 1 to 100 (A2:A10). In the second column titled 'STATUS' (B1), 'closed' or 'NA' is entered (B2:B10). Now I need to find how many cells are there in the table with 'closed' status in the range 0-25, 26-50, 51-75 and 76-100.
VALUES STATUS
34 Closed
56 NA
44 Closed
98 Closed
18 NA
82 NA
23 Closed
40 NA
63 Closed
71 Closed
Closed Status Count
0 - 25 :
26 - 50 :
51 - 75 :
76 - 100 :
please give me a solution.
Bookmarks