1 | Expense | Today | |||
|---|---|---|---|---|---|
2 | Coffee | $4.00 | |||
3 | Newspaper | $1.00 | |||
4 | Taxi | $10.00 | |||
5 | Golf | $26.00 | |||
6 | Taxi | $8.00 | |||
7 | Coffee | $3.50 | |||
8 | Gas | $46.00 | |||
9 | Restaurant | $31.00 | |||
10 | ... | ... | |||
11 | |||||
12 | |||||
13 | range | criteria | Result | Formula | |
14 | A2:A9 | "Taxi" | 2 | =COUNTIF(A2:A9, "Taxi") | |
15 | |||||
16 | |||||
17 | range | criteria | Result | Formula | |
18 | B2:B9 | >=10 | 4 | =COUNTIF(B2:B9, ">=10") | |
19 | |||||
20 | |||||
21 | range | criteria | Result | Formula | |
22 | B2:B9 | 10 | 4 | =COUNTIF(B2:B9, ">="&B22) | |
23 | |||||
24 | |||||
25 | range | criteria | Result | Formula | |
26 | A2:A9 | "G*" | 2 | =COUNTIF(A2:A9, "G*") | |
27 |
1 | Sample Data | ||||
|---|---|---|---|---|---|
2 | 1 | ||||
3 | 2 | ||||
4 | 3 | ||||
5 | 4 | ||||
6 | 5 | ||||
7 | 7 | ||||
8 | 2 | ||||
9 | |||||
10 | |||||
11 | Greater Than | Less Than | Result | Formula | |
12 | 2 | 7 | 3 | =MINUS(COUNTIF($A$2:$A$8, ">"&A12),COUNTIF($A$2:$A$8,">="&B12)) | |
13 | 4 | 7 | 1 | =MINUS(COUNTIF($A$2:$A$8, ">"&A13),COUNTIF($A$2:$A$8,">="&B13)) | |
14 | -4 | -1 | 0 | =MINUS(COUNTIF($A$2:$A$8, ">"&A14),COUNTIF($A$2:$A$8,">="&B14)) | |
15 |