writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 76:
Line 76: + + +
no edit summary
=SUMIF(B2:B6,">10") : Adds up the quantity of fruits that are greater than '10'. Returns '''50''' as a result.
=SUMIF(B2:B6,">10") : Adds up the quantity of fruits that are greater than '10'. Returns '''50''' as a result.
=SUMIF(A2:A6,"=Pear",C2:C6) : checks for the Pear fruit in the list and adds the price. Returns '''20''' as a result.
=SUMIF(A2:A6,"=Pear",C2:C6) : checks for the Pear fruit in the list and adds the price. Returns '''20''' as a result.
==Related Videos==
{{#ev:youtube|FlVuD39001g|280|center|SUMIF}}
==See Also==
==See Also==