BoAcharai › Lessons › Excel

Step-by-step lesson · Excel

How to use SUMIFS and COUNTIFS in Excel

5 steps

  1. Click an empty cell
  2. Type =SUMIFS(C2:C100, A2:A100, "North") to add up C where A is North
  3. Press Return
  4. Type =COUNTIFS(A2:A100, "North", C2:C100, ">100") in the next cell
  5. Press Return to count the rows that meet both conditions

More in Excel

All Excel lessons