Goal: To create 2 line items (current expense and non current expense) that auto populate once I create a data extract from a database and update the current date.
current expense: sum all line item values within current month and previous month IF the line items are a certain category.
noncurrent expense: same as above but for values 3 months or older from current month
example:
Here is a smaple data set:
<tbody>
</tbody><colgroup><col><col><col></colgroup>
current expense: I want to sum up all the "TM" document types if they are in the current month (january) or previous month (december)
noncurrent expense: I want to sum up all the "TM" document types if they are in prior to december
I would like the formulas that calculate each line item to be based off the current month
I've been trying to use SUMIFS and SUMPRODUCT but can't seem to get it down.
Thank you for any time and help!
current expense: sum all line item values within current month and previous month IF the line items are a certain category.
noncurrent expense: same as above but for values 3 months or older from current month
example:
Here is a smaple data set:
| Document Type | Posting Date | Amount in local currency |
| AC | 1/29/2015 | (159,017.00) |
| SA | 1/28/2015 | (598,716.15) |
| TM | 1/29/2015 | (14.50) |
| TM | 1/29/2015 | (814.00) |
| TM | 1/21/2015 | (1,520.00) |
| TM | 1/20/2015 | (115.05) |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
current expense: I want to sum up all the "TM" document types if they are in the current month (january) or previous month (december)
noncurrent expense: I want to sum up all the "TM" document types if they are in prior to december
I would like the formulas that calculate each line item to be based off the current month
I've been trying to use SUMIFS and SUMPRODUCT but can't seem to get it down.
Thank you for any time and help!
