writer
2,661
edits
Changes
→Examples
|}
|}
=SUMIF(B2:B6,"10",C2:C6) : Checks for the fruits with Quantity equal to '10' and adds the corresponding prices. Returns '''30''' as a result.
=SUMIF(B2:B6,"10",C2:C6) : Checks for the fruits with Quantity equal to '10' and adds the corresponding prices. <br />Returns '''30''' as a result.
=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.