FUNCTION SUMIF
SUMIF
This function adds the cells specified by a given criteria.
How does it work?
=SUMIF(range,criteria,sum_range)
Where:
RANGE is the range of cells you want evaluated.
CRITERIA is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, "32", ">32", "apples".
SUM_RANGE are the actual cells to sum.
Remarks
- The cells in sum_range are summed only if their corresponding cells in range match the criteria.
- If sum_range is omitted, the cells in range are summed.
This function adds the cells specified by a given criteria.
How does it work?
=SUMIF(range,criteria,sum_range)
Where:
RANGE is the range of cells you want evaluated.
CRITERIA is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, "32", ">32", "apples".
SUM_RANGE are the actual cells to sum.
Remarks
- The cells in sum_range are summed only if their corresponding cells in range match the criteria.
- If sum_range is omitted, the cells in range are summed.
Comments
Post a Comment
Your Valuable Comments are Appreciated