This is request formula from Miss Sri. How to use SUMIF formula?
SUMIF is a built-in formula in Excel. It means, that u don’t have to make it by yourself. U just use it and u have to know how to use it. Actually, you can read it in Ms Excel’s Help? And I think the Help is helpfull enough. But less application to the case.
SUMIF(range, criteria, sum_range)
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. 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.
U just put these formulas in cell of D16, D17, and D18:
There is another …IF formula: COUNTIF