In a Calc sheet, I’d like to sum all daily incomes grouped by month
The formula should depend on the (MM/YY formatted) “Month” column.
Why not just use a manual “SUM(…)” formula? Because I’d like to still be able to sort the source table and add rows to the result table by extension with the mouse.
SUMIF would do the job if I added a helper column C with something like “=DATE(YEAR(A), MONTH(A))” but that’s not so elegant, obviously.