Hope my title's not too misleading, I'll try to explain further. I've attached an example workbook for reference.
I need my SUM formula in column S to SUM the columns for each "area" defined for the data range in cells B2 and C2. Since B2 is 1/1/2013 I need the first column in the SUM to be the corresponding 1/1/2013 in column E. Since C2 is 12/1/2013 I need the last column in the SUM to be the corresponding 12/1/2013 in column P. For Area1 in Row5 it would be =SUM(E5:P5).
The catch is, I need the formula to be smart enough to change which column it picks based on the value in B2 and C2. If I change my range to 6/1/2013 in B2 and 8/1/2013 in C2 then Area1 needs to be =SUM(J5:L5).
If I can give any more detail, please, ask. Thanks for any help!
Bookmarks