Can there be any formula to give number as per count and as per criteria ?
Thanks in advance.
Queries.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Data | Result | |||||
2 | 3.00-3.99 | Range | Total Count | Numbering | |||
3 | 4.00-4.99 | 100-1.10 | 2 | 1 | |||
4 | 2.00-2.99 | 100-1.10 | 2 | ||||
5 | 1.00-1.49 | 1.11-1.20 | 3 | 1 | |||
6 | 0.50-0.69 | 1.11-1.20 | 1 | ||||
7 | 1.50-1.99 | 1.11-1.20 | 2 | ||||
8 | 1.50-1.99 | 1.21-1.30 | 4 | 1 | |||
9 | 3.00-3.99 | 1.21-1.30 | 1 | ||||
10 | 0.40-0.49 | 1.21-1.30 | 2 | ||||
11 | 0.70-0.89 | 1.21-1.30 | 2 | ||||
12 | 0.90-0.99 | 1.30-1.40 | 6 | 1 | |||
13 | 1.00-1.49 | 1.30-1.40 | 1 | ||||
14 | 2.00-2.99 | 1.30-1.40 | 1 | ||||
15 | 1.50-1.99 | 1.30-1.40 | 2 | ||||
16 | 1.00-1.49 | 1.30-1.40 | 2 | ||||
17 | 0.90-0.99 | 1.30-1.40 | 2 | ||||
18 | 0.50-0.69 | ||||||
19 | 0.30-0.39 | ||||||
20 | 0.40-0.49 | ||||||
21 | 1.00-1.49 | ||||||
22 | 0.70-0.89 | ||||||
23 | 1.50-1.99 | ||||||
Sheet1 (3) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3,D12,D8,D5 | D3 | =COUNTIF(C3:C19,C3) |
Thanks in advance.