Calculating total sums based on other cells

[johnmikecam]

I thought I had this figured out, but it's doing my head in now!

I'm trying to calculate the total value of WINS only.

Can anyone help? Thank you.

 

[jtakw]

Hi,

Book1
	A	B	C	D
2	Won	14000		32000
3	Lost	7000
4	Lost
5	Won	14000
6	Won	4000
Sheet443

Cell Formulas
Range	Formula
D2	=SUMIF(A2:A6,"Won",B2:B6)

 

[OilEconomist]

You would need to use SUMIF with "Won" or change the "Won" to "Win" and use a SUMIF with "Win". Here's the function for what you have. Just make sure you change the reference cells to where your cells are located.

=SUMIF($B$2:$B$6, "Won", $C$2:$C$6)

 

[johnmikecam]

jtakw an OilEconomist - thank you both very much. I think I did something similar earlier, but must have missed a step.

 

[jtakw]

You're welcome.