Results 1 to 2 of 2

Sumif with conditions?

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78

    Sumif with conditions?

    I have a table, in the table are cost and an X in a column of who the cost is accociated with. on some lines it is split between multiple people. So I want to split that cost between the people in my totals for each person. Its a christmas list.

    Example. 
    
    DESCRIPTION, Cost     , Tom, Beth, Mom, Dad,
    Visa Giftcard , $50.00  ,   X  ,   X  ,        ,      ,
    Laptop         , $400.00,       ,       ,    X  ,   X  ,
    Dad = $200.00
    Mom = $200.00
    Tom = $25.00
    Beth = $25.00

    Thank you for the help
    Last edited by WHWALDREP; 12-06-2009 at 03:29 PM.
    Excel 2007 SP1

Thread Information

Users Browsing this Thread

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

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