boxhamster
New Member
- Joined
- Jan 12, 2016
- Messages
- 14
Hi,
I can't seem to figure out what the mistake is.
I want to sum up the amounts depending on the type of expense and the month.
<tbody>
</tbody>
Using this formula:
<tbody>
</tbody>
Any idea what's going on?
Thanks
I can't seem to figure out what the mistake is.
I want to sum up the amounts depending on the type of expense and the month.
A | B | C | D | |
1 | Date | Item | Category | Amount |
2 | 28.02.2018 | Food | Food Shopping | 10,00 € |
3 | ||||
4 | Month | 2 | ||
5 | Food Shopping |
<tbody>
</tbody>
Using this formula:
= SUMIFS(D1:D3;MONTH(C1:C3);B4;C1:C3;B5) |
<tbody>
</tbody>
Any idea what's going on?
Thanks