+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    09-25-2016
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    2

    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. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,100

    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

    rather than an image - upload a real spreadsheet

    possibly with a little change in the data - or adding a helper column - you could use a pivot table to automate the results
    Last edited by etaf; 09-25-2016 at 02:58 PM.
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    09-25-2016
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    2

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

    https://drive.google.com/file/d/0B5o...ew?usp=sharing

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

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,100

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

    you can upload to the forum - rather than a link
    also NFL has a space
    "NFL "
    so that needs fixing
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding up profit and loss
    By TDN169 in forum Excel General
    Replies: 1
    Last Post: 08-09-2008, 01:13 PM
  2. [SOLVED] Calculating Profit and Loss in one column
    By Dismal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  3. Calculating Profit and Loss in one column
    By Dismal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] Calculating Profit and Loss in one column
    By Dismal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] Calculating Profit and Loss in one column
    By Dismal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  6. Calculating Profit and Loss in one column
    By Dismal in forum Excel General
    Replies: 0
    Last Post: 06-10-2005, 10:05 PM
  7. Calculating Profit and Loss in one column
    By Dismal in forum Excel General
    Replies: 0
    Last Post: 06-07-2005, 10:05 AM
  8. [SOLVED] Calculating Profit and Loss in one column
    By Dismal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2005, 09:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1