CODEWITHSUNDEEP
excelexcel-formula
Srijith Ramachandran
Srijith Ramachandran

Reputation: 71

Sumifs Dynamic Range

Iam using sumifs formula. My sumrange is dynamic and is based on the cell value. I have been able to get the column name by using the formula.

Now iam getting stuck when i try to reference the cell value(which has column name "g") to the range in sumifs, for example

=SUMIFS(LinkedIn!H:H,LinkedIn!A:A,Worksheet!B28). i want to change the range (H:H) with the column name which i have in the cell. i tried doing this "=SUMIFS(LinkedIn!D14:D14,LinkedIn!A:A,Worksheet!B28)" but its giving error. please advise.

regards, srijith

Upvotes: 2

Views: 775

Answers (1)

Variatus
Variatus

Reputation: 14383

This should work:- =SUMIFS(INDIRECT("LinkedIn!" & D14),LinkedIn!A:A,Worksheet!B28)

D14 should hold "H:H" or its equivalent.

Upvotes: 2

Related Questions