CodePudding user response：

Look into using SUMIF statements. Its always worth checking that all of your data has the same format and spelling as this can cause the statement not to work correctly.