How to Use Sumif MS Excel Together

1. Decide which cells you would like to sum. For example, you might want to sum cells in the range A1:A10.
2. Choose a criteria to sum by. For example, you might want to sum numbers that are less than 100. Other relevant criteria might be more than or equal to.
3. Place the SumIf statement in an empty cell:=SUMIF(A1:A10,'