I have the following spreadsheet:
I am trying to create a sumproduct formula (or one that will accomplish my task)
I have the following Data list options below my data chart as seen above...
I would like to be able to choose a site, choose a description ether Queries, Gross Revenue, or Allocable Revenue and the appropriate date
The above chart only covers feb but there are other Identical charts side by side so the next would be march 2007 "merged at the top every three columns" (unfortunaltely I cannot include this character limit for html post)
My problem is attempting to match the Date in row 1 first and then offsetting this by the desired choice of descriptions... since my dates are merged every three columns the sumproduct formula will lead me to the first column occurance of the correct date match from C1:T1 which by default is the Queries column...
Any suggestions on how I could get around this default if I preferred the Gross Revenue Column instead?
Any suggestions would be awesome
Thanks in advance,
GOOGLE SEARCH_ALLOCATION.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | February-07 | March-07 | ||||||||
2 | Site | Group | Queries | GrossRevenue | AllocableRevenue | Queries | GrossRevenue | AllocableRevenue | ||
3 | ||||||||||
4 | kctv | 21,626.00 | $87.73 | $61.41 | 26,275.00 | $66.12 | $46.28 | |||
5 | wpri | 17,434.00 | $66.46 | $46.52 | 17,948.00 | $32.12 | $22.48 | |||
6 | wave | 16,775.00 | $96.86 | $67.80 | 15,967.00 | $79.65 | $55.76 | |||
7 | KNDU | - | $- | $- | 5,880.00 | $13.96 | $9.77 | |||
8 | WGCL | - | $- | $- | 9,723.00 | $15.35 | $10.74 | |||
Summary |
I am trying to create a sumproduct formula (or one that will accomplish my task)
I have the following Data list options below my data chart as seen above...
GOOGLE SEARCH_ALLOCATION.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
26 | LOOKMEUP!!!! | ||||||
27 | Site | Group | Description | Date | ANSWER! | ||
28 | kctv | GrossRevenue | 2/1/2007 | ||||
Summary |
I would like to be able to choose a site, choose a description ether Queries, Gross Revenue, or Allocable Revenue and the appropriate date
The above chart only covers feb but there are other Identical charts side by side so the next would be march 2007 "merged at the top every three columns" (unfortunaltely I cannot include this character limit for html post)
My problem is attempting to match the Date in row 1 first and then offsetting this by the desired choice of descriptions... since my dates are merged every three columns the sumproduct formula will lead me to the first column occurance of the correct date match from C1:T1 which by default is the Queries column...
Any suggestions on how I could get around this default if I preferred the Gross Revenue Column instead?
Any suggestions would be awesome
Thanks in advance,