Hi,
I'm looking to SUM a set of values based on the name in the cell immediately to the left of the value, HOWEVER the cell to the left will be in a random column/row on the sheet, and there will be one name/value set for each week of the year. Thus, for week one, the name might be in cell A14, but in the next week, the name would be in cell C12, then E23, then G9, and so on. The corresponding value would be in the cell to the immediate right, as stated above.
Any help would be greatly appreciated!
Drahmee
I'm looking to SUM a set of values based on the name in the cell immediately to the left of the value, HOWEVER the cell to the left will be in a random column/row on the sheet, and there will be one name/value set for each week of the year. Thus, for week one, the name might be in cell A14, but in the next week, the name would be in cell C12, then E23, then G9, and so on. The corresponding value would be in the cell to the immediate right, as stated above.
Any help would be greatly appreciated!
Drahmee