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