Excel help no. infinity

Tobes Rafa · December 16, 2013

I'm sure this is piss easy for most of you but I'm putting together a 3 year business plan and the spreadsheet I have inherited could do with a bit of a tidy up.

I have a list of event categories in Column A, forecasting the events per month.

Concert-small

Concert - standing

Comedy

Sport

Ice Hockey

etc.

Column B has the equivalent code alongside each category eg. CM, CS, S, IH etc

The rest of the spreadsheet is about 60 columns of info. on each eg. attendance, rent, F&B per head, merch per head, event costs, % tickets sold in-house etc.

To date this has all been entered by hand but I want to streamline everything so I can have a "reference" section below. At the moment I have it all set up using "If" formulae as below

(IF(C26="CH",G$173,"0")+IF(C26="CL",G$174,"0")+IF(C26="CS",G$175,"0")+IF(C26="CM",G$176,"0")+IF(C26="IH",G$179,"0")+IF(C26="S",G$181,"0")+IF(C26="F",G$182,"0")+IF(C26="TS",G$183,"0")+IF(C26="Ent",IF(B26="WWE",G$180,G$184))+IF(C26="CMS",G$177,"0"))*D26

but there is surely an easier way to do this, I just don't know what it is.

I have the reference info directly below the annual forecast and I am able to type in a figure of say £4.50 for F&B per head for concert small and for it to update all the concert smalls. It all balances but it's just messy as fook and I want to simplify it in case I'm not arouns to make changes.

Any ideas?

Thanks

Stanley Leisure · December 16, 2013

This post is not viewable to guests.

You can sign in to your account at the login page here