Hi, I am hoping I could get some assistance with an issue I am having on Excel!
Let me start by saying I have searched other topics within the forum and can't seem to find the code which suits what I need...so here goes
I have been trying to use a vlookup and a sum formula to find a show name, then calculate the total tickets sold for that show, and return the overall value on a different worksheet.
I have taken some screen shots here...
so for example, I want to add the values of Grease together and then return the total into screen shot one....I've been having a nightmare all day with it but I am hoping its something quite simple I am doing wrong
Thanks in advance
Let me start by saying I have searched other topics within the forum and can't seem to find the code which suits what I need...so here goes
I have been trying to use a vlookup and a sum formula to find a show name, then calculate the total tickets sold for that show, and return the overall value on a different worksheet.
I have taken some screen shots here...


so for example, I want to add the values of Grease together and then return the total into screen shot one....I've been having a nightmare all day with it but I am hoping its something quite simple I am doing wrong
Thanks in advance
