The syntax for the SUMIFS function depends on the number of conditions needed.

Each separate condition will require arangeand acriteria.

Notice the conditions (calledcriteria) are entered inpairs.

Excel formula: Sum if x or y

Each new condition requires a separaterangeandcriteria.

This means we need to include thelogical operator(>) in the second criteria.

Excel formula: Sum if date is between

Excel formula: Sum last 30 days

Excel formula: Sum by month

Excel formula: Sum if cells contain specific text

Excel formula: Count if two criteria match

Excel SUMIFS function

Article image

Article image