Results 1 to 3 of 3
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Selective Addition

    This should be easy, I think, but I just woke up and my mind is still foggy. I've played with it for far too long, so it's time to ask for help.

    I have two columns, each a named range. The first column is named and headed 'Lottery', and the cells below the heading are either blank or contain one of two words: "Powerball" or "Mega Millions". The second column is named and headed 'Cash Value', and the cells below the heading are blank if the corresponding 'Lottery' cell is blank, or a number if it isn't.

    I want to set up two cells, one holding the total of the 'CashValue' cells where the corresponding 'Lottery' cell contains the word "Powerball", and one where it contains the words "Mega Millions".

    In other words, I want one cell to contain the sum of the Powerball values, and another to contain the sum of the Mega Millions values.

    (I hope my mind is clear enough to have stated my problem correctly.)

    Who can help?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Cash Value is not a valid name, I assumed you named it "CashValue":
    =SUMIF(Lottery,"Powerball",CashValue)
    =SUMIF(Lottery,"Mega Millions",CashValue)

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    Lou Sander (2013-03-30)

  4. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    That does it!

    Yes, I named it properly. I just didn't put it correctly in my question.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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