Excel 2007 – How to get the SUM value in Multiple Criteria
How do I get to sum the values in a range that meet criteria that you specify?
We can use SUMIF() formula to do that. Besides, we also can use SUMIF() worksheet function for the following situations:
- When you want to return a sum for a single criteria (for example, a single IF condition)
- When you want to use multiple criteria and return the sum to multiple cells
Syntax:
SUMIF(range, criteria, [sum_range])
Example:
- The table above has shown the total exam marks from 1st class students, in which Grade (in column B) and Marks (in column C) are clearly stated.
- By using ‘SUMIF’ formula, I am able to get the total marks of those students that scored A :
Formula: =SUMIF(B2:B11,”A”,C3:C11)
The results are shown in the below table.
Comments
One Response to “Excel 2007 – How to get the SUM value in Multiple Criteria”
Leave a Reply
[...] post, i have show how to use “SUMIF” function. I will continue use the table from previous post to show how to use SMALL function in Microsoft Excel [...]