SUMIFS

SUMIFS allows you to test several conditions and bring back a value according to those conditions. For instance, you could use SUMIFS to sum the amount of prospects registered by a particular salesperson.

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

  • =SUMIFS(A4:A11,B4:B:11,B14,C4:C11,A14)
  • Sum the values in the cell A4 to A11 for the rows where the value in B4 to B11 is B14, and the value in C4 to C11 is A14.

Steps

  1. Choose a cell.
  1. Enter =SUMIFS, and a left parenthesis (.
  1. Click the sum range, and type a comma.
  1. Confirm the first criteria range, and type a comma.
  1. Set the criteria, and enter a comma.
  1. Decide the second criteria range, and enter a comma.
  1. Choose the criteria, and type a comma.
  1. Hit Enter.
%d bloggers like this: