Calculating total sums based on other cells

johnmikecam

New Member
Joined
Jan 22, 2017
Messages
5
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.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
Hi,

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Won</td><td style="text-align: right;;">14000</td><td style="text-align: right;;"></td><td style="text-align: right;;">32000</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Lost</td><td style="text-align: right;;">7000</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Lost</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Won</td><td style="text-align: right;;">14000</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Won</td><td style="text-align: right;;">4000</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:6.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet443</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D2</th><td style="text-align:left">=SUMIF(<font color="Blue">A2:A6,"Won",B2:B6</font>)</td></tr></tbody></table></td></tr></table><br />
 

OilEconomist

Board Regular
Joined
Dec 26, 2016
Messages
192
Office Version
2019
Platform
Windows
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.

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

johnmikecam

New Member
Joined
Jan 22, 2017
Messages
5
jtakw an OilEconomist - thank you both very much. I think I did something similar earlier, but must have missed a step.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,142
Messages
5,472,754
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top