How to call named field in excel formula through reference

excel excel-formula

29 просмотра

1 ответ

I am trying to re explain my issue, Column A, B, C, has numbers between 1 to 100 till 500 cells and I named column A as Feb, Column B as Mar & Column C as Apr... Now I Have created one vba dropdown and it has the values February, March, April...... Now I want if i select January then sum of Jan named values sum i should get in result and if i select February then Feb named column values sum i should get... I want formula for this but I dont want to write Named in formula three times for january, February, March, so suggest me the alternative...

Автор: skroutela Источник Размещён: 08.11.2019 11:15

Ответы (1)

0 плюса

If your dropdown is in D1 and Jan, Feb, Mar is in row 1 then use,

=sum(index(a:c, 0, match(d1, 1:1, 0)))

enter image description here

Автор: user4039065 Размещён: 20.08.2016 03:20
Вопросы из категории :