Sum If Exercise
I was curious on the exercise for SUM, SUMIF, SUMIFS... I followed the syntax and kept getting a returning value of 0.
Rather than calling out the desired cell "L5" for Sony (like the video shows) the solution directly stated "Sony" to get the total quantity of 191.
Did I not get the logic correctly regarding SUMIF & SUMIFS or does the new version of Excel make it okay to simply call the criteria in quotes?
Thanks in advance!
2 answers ( 0 marked as helpful)
| SUM(number1,[number2],[…]) | Direct Select the range of numbers you want to sum |
| SUMIF(range,criteria,sum_range) | criteria_range then criteria then the range of numbers you want to sum |
| SUMIFS(sum_range,criteria_range1,criteria1,[criteria_range2,criteria2],[…]) | the range of numbers you want to sum then criteria_range1,criteria1 then criteria_range2,criteria2 |
Example:
| A | B | C | D |
|---|---|---|---|
| A | Cat | 5 | |
| D | Dog | 8 | |
| W | Cat | 9 | |
| D | Cow | 6 | |
| A | Dog | 3 | |
| V | Cow | 4 | |
| E | Cat | 7 | |
| H | Lion | 9 | |
| A | Cat | 5 | |
| E | Cow | 2 | |
| H | Dog | 3 | |
| D | Cat | 8 | |
| =SUM(C1:C12) | 69 | ||
| =SUMIF(A1:A12,"A",C1:C12) | 13 | ||
| =SUMIFS(C1:C12,A1:A12,"A",B1:B12,"Cat") | 10 |
The L5 cells stated "sony:" but the formula couldn't find from the range of A2-A51 that says "sony:" hence the error. The solution is to get the criteria from A4 because it only says "sony".