Last answered:

25 Jan 2023

Posted on:

15 Nov 2022

0

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)
Posted on:

15 Nov 2022

1
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
Posted on:

25 Jan 2023

0

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".

Submit an answer