+ Reply to Thread
Results 1 to 3 of 3

SUMIFS? or a different method to calculate multiple fields?

  1. #1
    Registered User
    Join Date
    09-06-2012
    Location
    the desert
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy SUMIFS? or a different method to calculate multiple fields?

    Risk To Win Amount Paid Status Running Total

    $12.80 $10.00 $22.80 Win xxxxxx
    $15.30 $10.00 $0.00 Loss
    $11.70 $10.00 $0.00 Loss
    $10.90 $10.00 $20.90 Win
    $12.00 $10.00 $12.00 Cancelled


    So I have the following in an excel sheet and I"m trying to calculate the running total. I attempted to do a
    =SUMIFS(Amount_Paid, Status,"=Win") Which provides a total for wins but I need to calculate the following:

    If Status="Win" add total the Amount Paid.
    If Status="Cancelled" add total to Amount Paid.
    If Status="Loss" subtract Risk to total.

    I've been trying to figure this out with no solution. Thanks for any help and it's greatly appreciated!

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: SUMIFS? or a different method to calculate multiple fields?

    =SUM(SUMIF(Status,{"Cancelled","win"},Amount_paid))-SUMIF(Status,"Loss",Risk)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    09-06-2012
    Location
    the desert
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: SUMIFS? or a different method to calculate multiple fields?

    Ha! Thanks Ace!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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