We have multiple groups that make up a large number of Capital Projects including the actual spend of those projects. We have also been given a large sum of money to make those projects happen. We would like to be able to subtract actual costs from each group from the the total sum of money given to show how much money we have left. There are also times we need to be able to do math on specific cells and have to export everything to excel, having a sum function that works like excel (where cells can be chosen) would be extremely beneficial.

You might want to checkout SpreadsheetWeb integration monday.com: Apps Marketplace. You can embed Excel formulas and connect them to your columns on the board. See more at monday SpreadsheetWeb - SpreadsheetWeb Help.

Full disclosure: I work at SpreadsheetWeb. If you have any question, I will be happy to help.