Advanced Excel Formula =SUMIFS example

Advanced Excel Formula =SUMIFS example

SUMIFS

Function is an advanced version of SUMIF function where SUMIF validates only one criteria but SUMIFS allows multiple criterias (upto 127) to be evaluated at a time. In this article we will see detail example of SUMIFS functions.

Syntax

=SUMIF(sum_range, criteria_range1, criteria1, criteria_range, criteria2….)

Query

SELECT SUM(Salary) WHERE Employee Name = “A” and Age=85

Steps

  1. Type =SUMIFS sign in the cell and start bracket (
  2. Select sum_range parameter from “C2:C21”
  3. Put comma (,) to terminate the condition
  4. Select “A2:A21” to fill criteria_range1
  5. Put comma (,) to terminate the condition
  6. Put =”A” to fill criteria1
  7. Put comma (,) to terminate the condition
  8. Select “B2:B21” to fill criteria_range2
  9. Put comma (,) to terminate the condition
  10. Put =85 to fill criteria2

Formula

Hit Enter and notice the sum tally with Row Number 2 and Row Number 13 of Salary column in the source data:

Output

Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.

Leave a Reply

Your email address will not be published.