Hey everybody, I am trying to solve a problem in Excel but I am having a lot of difficulty finding the right equation.
Ultimately I am trying to create a formula that would answer the following question:
-For the month of X, whats is the ROI for marketing bucket Z
-To put it more concretely: For the 3d month of 2011, what is the ROI for marketing bucket SEM
So the steps I
would follow are:
1) In a cell, I enter the following value "SEM"
2) In a different cell, I enter the following value "1/2011"
3) Excel takes the value SEM, goes to spreadsheet ZTM, searches for all rows that are labeled SEM Revenue and SEM Cost
4) Then, Excel would calculate (REVENUE - COST) / COST, but the values it would use for the calculation are the values that
are located under the column for the month of January, 2011. So that if I needed to calculate ROI for SEM for 2/2011, I could
simply just change the data in step 1 and step 2.
I hope I am being clear in my explanationů.
going in the direction of a SUMIF formula with an OFFSET function embedded in it to limit it to only the months needed for