DENISEKELLY
New Member
- Joined
- Oct 10, 2019
- Messages
- 3
Hello!
I have created this chart to track company travel for the year. I wanted the chart to be sortable so I could look at the number of trips a team, individual, etc. are taking each month and the costs associated.
Where I am getting stuck is the monthly totals formula. I need the monthly spend to act as subtotals, and disregard rows that are not visible when sorted.
If I were to imagine the formula to get determine my February spend it would be this: SUBTOTAL(SUMIF(F2:F18,"FEBRUARY",I2:I18)
Can you help me figure out this formula, assuming I have already sorted the table as such?
Thanks in advance!
<tbody>
</tbody>
I have created this chart to track company travel for the year. I wanted the chart to be sortable so I could look at the number of trips a team, individual, etc. are taking each month and the costs associated.
Where I am getting stuck is the monthly totals formula. I need the monthly spend to act as subtotals, and disregard rows that are not visible when sorted.
If I were to imagine the formula to get determine my February spend it would be this: SUBTOTAL(SUMIF(F2:F18,"FEBRUARY",I2:I18)
Can you help me figure out this formula, assuming I have already sorted the table as such?
Thanks in advance!
A | B | C | D | |
1 | TEAM | REGION | MONTH | COST |
9 | OPS | ASIA | JANUARY | $18000 |
12 | SALES | EUROPE | FEBRUARY | $6000 |
15 | CFO | ASIA | JANUARY | $18000 |
16 | ||||
17 | ||||
18 | JANUARY SPEND | ??? | ||
19 | FEBRUARY SPEND | ??? | ||
20 | MARCH SPEND |
<tbody>
</tbody>