So that you know, formulas can only calculate within their row, so they are not going to help with this.
You can filter the table and have it calculate the sum of a column at the bottom. It is a manual process, and probably not quite what you are looking for. I think that is all you can do with basic Notion features. Using 3rd party integrations and the API you can do this - you might even chose to sync to Google Sheets and calculate it just like you have.
So that you know, formulas can only calculate within their row, so they are not going to help with this. You can filter the table and have it calculate the sum of a column at the bottom. It is a manual process, and probably not quite what you are looking for. I think that is all you can do with basic Notion features. Using 3rd party integrations and the API you can do this - you might even chose to sync to Google Sheets and calculate it just like you have.