Following are the function you can use for SUM range with different criteria in Microsoft Excel. It is useful for you while working in Excel.
SUM function returns the sum of values supplied as multiple arguments.
SUMIF is a function to sum cells that meet a single criteria. SUMIF can be used to sum cells based on dates, numbers, and text that match specific criteria
SUMIFS is a function to sum cells that meet multiple criteria. SUMIFS can be used to sum values when adjacent cells meet criteria based on dates, numbers, and text.
See Video - https://youtu.be/JWktylyYeN0