As @bentyre1 mentioned, there are a few ways to do this… The Category Tracker is a way to do this with live in-sheet formulas. You can also use the Category Rollup Report with the Tiller Community Solutions add-on which creates a standalone static sheet through scripts.