A | B | C | D | |
1 | Date (ddmmyyyy) | City | Department | Expense |
2 | 01-11-2015 | Memphis | HR | 6000 |
3 | 31-11-2015 | FortWorth | HR | 7000 |
4 | 31-11-2015 | Memphis | HR | 8000 |
5 | 01-12-2015 | Memphis | HR | 9000 |
6 | 01-12-2015 | Memphis | Operations | 10000 |
<tbody>
</tbody>
I want to calculate the expense for current month i.e. Nov for HR department in Memphis,
Answer should be 14000 (i.e.6000+8000),
I am using the formula:
SUMIFS(D:D,B:B,"Memphis",C:C,"HR",A:A,MONTH(A:A)=MONTH(TODAY()))
I tried entering with CTRL+ALT+Enter, but it gives error "#Value",
I am looking to include Current Month the formula, so that in dec, excel can calculate expenses for dec.