Formula to calculate sum of column whose order changes from month to month

Hi All

I am looking for help with a formula. I have attached my spreadsheet for better explanation of what I'd like to do.

On the 'Excel Reporting Templates' tab, I would like to calculate the totals for B43 and B44 as follows.

B43 = The sum of 3rd Party Host Connection Problem + Invalid Input File in 'B' column. The values for each of these is pulled from a monthly sheet, i.e. January Source Data and is updated each month.

B44 = The sum of all other 'Category' values excluding the two I mentioned above, i.e. Deployment Errors + TokenEx Upload/Download Errors, etc...

The problem I am having is that I need to be able to reorder the 'Category' in column A, sorting from smallest to largest value in column B so that it appears that way on a seperate graph. The order will theoretically change each month, so my attempt at simply getting the sum of two fixed columns does not work when I reorder the data.

I hope that I am being clear with the request. Any help is always appreciated.

Thanks @DFLAK for the quick response. That formula is perfect and exactly what I needed!

Your help is much appreciated!