SUMIF Formula

Catogory: Bulit-in Formula
Level: Beginner

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.

OK. I will use the data from the previous posting, AVERAGEIF Formula. The goal is to find the sum of each subject.



U just put these formulas in cell of D16, D17, and D18:
=SUMIF($C$3:$C$13,C16,$D$3:$D$13)
=SUMIF($C$3:$C$13,C17,$D$3:$D$13)
=SUMIF($C$3:$C$13,C18,$D$3:$D$13)
respectively.

There is other ...IF formula: COUNTIF