Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Mar 2007
    Location
    Canada
    Posts
    32
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Question Sum - if a4 = "x" and w4="20" add up all the w4=20's in the rows from row named nameA to nameB

    Sum - if a4 = "x" and w4="20" add up all the w4=20's in the rows from row named nameA to nameB

    Or something like that...

    Here's what I have:

    a spreadsheet for registrations for an event, each row is a person, and column A gets the name of the registration type, e.g. "Two Day Pass" or "Friday Pass" etc, and W gets the amount charged. AND depending on WHEN they registered, the amount charged in W varies, thereby the complexity.

    I need all the types and varying amounts so we can work out how many of each and what worked and didn't in the promo.
    ---------------
    Ideally the formula would get the values to look up from a table with the various combinations. i.e.
    Sum in cell C50 would get it's values from a table with "Two Day Pass" in A50 and "@0" in B50, etc.
    --------------

    Hope all that makes sense!

    Thanks for ANY help, I'm not an Excel whiz, more a script kiddy
    Grant

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Could you post a sample of the workbook?

  3. #3
    Lounger
    Join Date
    Mar 2007
    Location
    Canada
    Posts
    32
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Here you go, guess I didn't describe as well as I might

    Hopefully the attached will make it clear.

    thanks!
    Last edited by GrantHorizons; 2014-02-10 at 15:37.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Should the sheet you attached have rows of people? It doesn't. It has two small tables that I suspect are what you want to fill out...but, there isn't any data to based the calculations upon.

  5. #5
    Lounger
    Join Date
    Mar 2007
    Location
    Canada
    Posts
    32
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Each row would have user information such as email address and names, certainly - didn't think it was necessary as it shouldn't be relevant. I tried to keep it simple and focussed!

    The first section is the rows of people, the second is the results. Sorry I now realise that wasn't clear!

  6. #6
    Lounger
    Join Date
    Mar 2007
    Location
    Canada
    Posts
    32
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Attached is a perhaps clearer example.

    Thanks!
    Attached Files Attached Files

  7. #7
    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
    Something like this in C13. Adjust as needed and copy down the column.
    =COUNTIFS($A$4:$A$9,A13,$W$4:$W$9,B13)

    Steve

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

    GrantHorizons (2014-02-10)

  9. #8
    Lounger
    Join Date
    Mar 2007
    Location
    Canada
    Posts
    32
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Nice, thanks Steve! That works great. A little playing with ranges and it's sorted.

    Thanks a bunch, that makes my sheet MUCH nicer than my solution... you don't wanna know....

    Grant

Posting Permissions

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