Tuesday, November 19

DSUM Function To Sum For Specific Criteria

SYNTAX : =DSUM ( Database , Field , Criteria)

  • DATABASE: The Whole Table Or A range of Cells With Header.
  • FIELD: The Label Or You Can Say Header Of The Table / Range
  • CRITERIA: Single Or Multiple Range With Header.

NOTE : You Can Have The Field In Separate Column As This Example Have Or You Can Directly Pick Any Of Those Directly From The Table Header By Giving Reference.

EXAMPLE 1 :

EXAMPLE 2 :

EXAMPLE 3 :

Leave a Reply

Your email address will not be published. Required fields are marked *