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 / RangeCRITERIA: 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 :