Adding 2 New Prices to Ticket Tracker Template

[williamfhubbard]

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!
[h=2][/h]

 

[mumps]

Can you upload a file that includes a sheet which shows the desired results?

 

[williamfhubbard]

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.

 

[mumps]

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.

 

[Fluff]

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?

 

[williamfhubbard]

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

 

[Fluff]

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)

 

[williamfhubbard]

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

 

[Fluff]

You're welcome & thanks for the feedback