multiple formulas needed in one cell to create a value in a new cell

[jamietofs]

Hi there,

I posted a question here a few weeks ago and had an extremely helpful response, so thought I would try my luck with a new question relating to the same sheet.

As it is a fairly long-winded question, I've attached a "step-by-step" on what it is I am trying to achieve, as well as the excel document I'm trying to implement it in.

I don't really need an answer to this at this stage. I'm just trying to figure out if what I'm trying to do is actually possible.

Any help would be greatly appreciated!

Thanks.

sales tracking formula.docxMedia Tracking Sheet.xlsx