# Help with win loss and tie column & adding profit based on win or loss.

1. ## Help with win loss and tie column & adding profit based on win or loss.

I'm trying to configure my sports book and I want to be able to see my statistics based upon each sport as well as overall. I posted a screen shot of the sheet so you guys can see what I am trying to do.

I want to be able to see my Win, Loss, and Tie record in that format. But I want the overall which would be based upon the entire column. and I also want to see indivudal sports..

I also want the sheet to record my profits. So if the cell reads "loss" it will subtract that amount and if it read "Win" it will add the amount. Untitled.png

2. ## Re: Help with win loss and tie column & adding profit based on win or loss.

you can use countif() and countifs()
so overall
countif(E:E, "loss") - will count the loss
countif(E:E, "win") - will count the win

not sure what PUSH means

for different groups
NFL
=COUNTIFS( E:E , "Win", B:B, "NFL" ) we can use cells for NFL and WIN rather than hardcode

how do we work out a profit and loss
do you mean Cell D:D
in which case a combination of SUMIF() and a SUMIFS()
sumif(E:E, "win",D:D)- sumif(E:E, "loss",D:D) - will sum the difference between the win and the loss wagers

possibly with a little change in the data - or adding a helper column - you could use a pivot table to automate the results

3. ## Re: Help with win loss and tie column & adding profit based on win or loss.

There is a copy. I will try your suggestions and see what I can do. I am still new to this

4. ## Re: Help with win loss and tie column & adding profit based on win or loss.

also NFL has a space
"NFL "
so that needs fixing

There are currently 1 users browsing this thread. (0 members and 1 guests)