Results 1 to 9 of 9

Thread: Adding 2 New Prices to Ticket Tracker Template
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adding 2 New Prices to Ticket Tracker Template

    I am a newbie with Excel and could use help.
    I am trying to use a template for Ticket Tracking for our Non profit Theatre.
    Here is the template I am working on.

    https://1drv.ms/x/s!AvrJXpPq_XWokllNt6BaJTbrlgJI

    I would like to add 2 new prices under D3.

    Could anyone guide me on this? Thanks!

  2. #2
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,235
    Post Thanks / Like
    Mentioned
    89 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    Can you upload a file that includes a sheet which shows the desired results?
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    Quote Originally Posted by mumps View Post
    Can you upload a file that includes a sheet which shows the desired results?
    https://1drv.ms/x/s!AvrJXpPq_XWoklvxi3I6x61AAPAn

    I hope this works......this is kinda what I would like for it to look like.

  4. #4
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,235
    Post Thanks / Like
    Mentioned
    89 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    I'm sorry but I don't quite understand what you want to do. If all you want is "to add 2 new prices under D3", you have already done that manually in the second file you posted. Why not use that second file which contains the added prices? Do you want those extra cells to be added automatically rather than manually? if so, what would trigger that addition? Please explain in detail, step by step, what you want to see happen referring to specific cells, rows and columns using a few examples from your data.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #5
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,964
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    Why not just set up 2 more named ranges, the same way you have done for the first three columns, and add that to your total formula?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  6. #6
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    Quote Originally Posted by mumps View Post
    I'm sorry but I don't quite understand what you want to do. If all you want is "to add 2 new prices under D3", you have already done that manually in the second file you posted. Why not use that second file which contains the added prices? Do you want those extra cells to be added automatically rather than manually? if so, what would trigger that addition? Please explain in detail, step by step, what you want to see happen referring to specific cells, rows and columns using a few examples from your data.
    thanks for responding

    I did not set this up, it was a template found online.

    The second file is what I would like it to be. I was able to write a formula for total tickets sold (E6) but when I try and write a formula to include the 2 new costs (E4,E5) it does not work.It does not add to total ticket sales (E9)

    I would like to be able to add a ticket sale in column F and G and have it be added to the total ticket sales E9 in addition to the total tickets sold.......(E9 and E6)

    If person 1 buys a ticket in each category, (Adult, Child, Discounted, 2 for 15 and 2 for 1), I would like to see a total of 5 Total tickets sold and a total ticket sales of $48.

    I'm sorry but I just don't know enough to write a formula to this. I did write the E6 formula just by adding the 2 extra categories F11 and F12.When I tried to do that again for E9, it did not work.
    Thanks

  7. #7
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,964
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    Ok, how about
    =SUM(SUM(Tickets[Adult])*AdultCost,SUM(Tickets[Child])*ChildCost,SUM(Tickets[Discounted])*DiscountCost,SUM(Tickets[2 For 15])*E4,SUM(Tickets[2 For 1])*E5)
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  8. #8
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    Quote Originally Posted by Fluff View Post
    Ok, how about
    =SUM(SUM(Tickets[Adult])*AdultCost,SUM(Tickets[Child])*ChildCost,SUM(Tickets[Discounted])*DiscountCost,SUM(Tickets[2 For 15])*E4,SUM(Tickets[2 For 1])*E5)
    YES YES YES!!!
    Oh thank you so much. This is just not in my wheelhouse. I do comedy, not spreadsheets!
    This will really help our Non-Profit Theatre!!

    http://freerangecomedy.com

  9. #9
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,964
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Adding 2 New Prices to Ticket Tracker Template

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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