Forum Discussion
TOTAL of the month (just)
Hi Community, I need to have the all of the spending corresponding for the current month. I have tried TOTALMTD and DATESMTD but in the last case it added until last row, even if it's in the differe...
You could add an extra column (maybe hide it if you want) where you show the month by using MONTH(Date).
You can them use SUMIFS and check the MONTH column.
Another possibility - depending on your data it may be easier to use a pivot table?
Hope this helps.
Peter