(11) How to use SUMIFS formula in Microsoft Excel.
SUMIFS: Adds the cells in a range that meet multiple criteria.
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Example-1:
| Formula |
Description |
Result |
| =SUMIFS(E3:E14,B3:B14,"Section-A") |
Returns the Section-A total production.
here, sum_range=E3:E14, criteria_range1=B3:B14, criteria1="Section-A". |
3550
|
Example-2:
| Formula |
Description |
Result |
| =SUMIFS(E3:E14,B3:B14,"Section-A",D3:D14,"Pant") |
Returns the Section-A total production.
here, sum_range=E3:E14, criteria_range1=B3:B14, criteria1="Section-A", criteria_range2=D3:D14, criteria2="Pant". |
3250
|
Video:
How to use SUMIFS formula in Microsoft Excel:
|