CODEWITHSUNDEEP
excelexcel-formula
Francisco Plácido
Francisco Plácido

Reputation: 115

Can I use a cell to tell me which column to use on a SUMPRODUCT formula?

I have the following formula below: =SUMPRODUCT('EC(C)DB'!M:M;--(ISNUMBER(MATCH('EC(C)DB'!A:A;$A$33:$A$39;0))) ...

The column which I want to sum (M:M) is variable depending on one Cell. Anyway I can have the formula look at that cell? I can make that cell store M:M or just M, or 13. Nothing like that seems to work.

I could use a series of ifs, with all of the sumproduct possibilities and different columns but that doesnt look very efficient.

Thank you for your time!

Upvotes: 0

Views: 29

Answers (1)

UndeadBob
UndeadBob

Reputation: 1129

Check out OFFSET and just set the column argument to the "one Cell"

Upvotes: 1

Related Questions