How to sum values by month from Date column?


What I want is to create a sum of sales by month. Those dates dates need to read and updated from a Date column.

Here is my table

For example, I want to see what is the TotalPrice for August, September etc.

How to achieve that?!


Make a new column with a formula that formats the date as a string containing just the year and month. Then create a summary table grouped by that new column.

By the way, there is a recipe for getting year + month from a date here: Recipe for getting Months and Quarters from dates

If you need help with summary tables, we have a video guide here which covers a use case similar to this (totaling expenses by month): Summary Tables Guide - Grist Help Center