If anyone could please help me with this, I'm not an advanced excel user. I've had classes but can't remember everything that I've learned from them. My problem is that i need to be able to create a formula that will give me a sum by referencing cells in say row 1 but out of a changing number of columns that doesn't exceed column BL but retrieving numbers from row 26 of the same column if the letter in column 1 of that same column equals a certain letter. Kind of like an IF function combined with sum and offset. I have 4 different formulas that will be the same but i need to make them work only if the cells in row 1 equal A, B, C, or D respectively.