Hi all - First off im new to all this so go easy on me...

My whole reason for joining is im trying to solve a month old problem: I want to search a different column for data based on criteria in a cell.

As an example

If A1="B:B" then SUM Column B
If A1="C:C" then SUM Column C
If A1="D:D" then SUM Column D
And so on….

Maybe im looking at this in the wrong way, but to my data dump requires me to search a very large array of information that is different each week and so i need a flexible formula

Thanks in advance (incase someone cant solve this, then thanks for trying)