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 | range | criteria | sum_range | Sum | Formula | |
13 | A2:A9 | Taxi | B2:B9 | $18.00 | =SUMIF(A2:A9, "Taxi", B2:B9) | |
14 | ||||||
15 | ||||||
16 | range | criteria | sum_range | Sum | Formula | |
17 | B2:B9 | >=10 | B2:B9 | $113.00 | =SUMIF(B2:B9, ">=10", B2:B9) | |
18 | ||||||
19 | ||||||
20 | range | criteria | sum_range | Sum | Formula | |
21 | B2:B9 | >=10 | $113.00 | =SUMIF(B2:B9, ">=10") | ||
22 | ||||||
23 | ||||||
24 | range | criteria | sum_range | Sum | Formula | |
25 | B2:B9 | 10 | $113.00 | =SUMIF(B2:B9, ">="&B25) | ||
26 | ||||||
27 | ||||||
28 | range | criteria | sum_range | Sum | Formula | |
29 | A2:A9 | "G*" | B2:B9 | $72.00 | =SUMIF(A2:A9, "G*", B2:B9) | |
30 | ||||||
31 | ||||||
32 | range | criteria | sum_range | Sum | Formula | |
33 | A2:A9 | <>Taxi | B2:B9 | $111.50 | =SUMIF(INDIRECT(A33),B33,INDIRECT(C33)) | |
34 |