SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

The go-to function for that is usually VLOOKUP, and understandably so. This function will take a table, find a value in the left-most column, and return the value from the desired column. Home tech ...