Excel question: using AND in a summation formula (Solved)

[IronWing]

This formula sums the value in column D if column C contains "Apples".
=SUMIF(C22:C43, "Apples", D22😀43)

This formula sums if the value in column D is greater than zero.
=SUMIF(D22😀43,">0")

What I'd like to do is write a formula that sums the values in column D if both conditions are true, that is, column C contains Apples and the value in column D is greater than zero. Any ideas on how write the AND statement? Thanks.

 

[mpo]

SUMIFS will sum multiple criteria.
https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b

 

[IronWing]

Thank you, that worked perfectly. 🙂

 

[Binky]

Sumproduct also works.