SUMIFS FORMULA IN EXCEL

SUMIFS is a feature to sum cells that fulfill numerous requirements. SUMIFS can be used to sum values when corresponding cells satisfy standards based on days, numbers, as well as text.

=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)

Sum_range – the range of cells to sum.

Criteria_range1 – the range that is tested using Criteria1.

Criteria_range2, criteria2, … (optional) additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.