If/then question

[Gettingbetter15]

Good morning!
I'm so grateful this website is here! I hope someone out there can help me. Based on the table below, I want to create an if/then statement in the cell to the right of the Total cell subtracting all Orange values from Apple values. I know this can be done, just don't know how. Can someone help me please? I can't wait to hear from you and thank you so very much!

A	B
Apples	25
Oranges	16
Apples	113
Oranges	29
Total

<tbody>
</tbody>

 

[BarryL]

=SUMIF(A2:A5,"Apples",B2:B5)

just add the apples values

 

[Rick Rothstein]

Give this a try...

=SUMIF(A1:A4,"Apples",B1:B4)-SUMIF(A1:A4,"Oranges",B1:B4)

 

[Gettingbetter15]

Awesome! Thank you both for your help! I appreciate it so much! I'm going with Mr. Rothstein's response bc it provides the difference between both, which is what I was looking for! Have a great rest of your week!