Excel Program with Dropdown List

[kkengps]

Hi Gurus..

One excel sheet with different tabs.

Tab 1: Summary
In this summary tab, I have many items.
A -> Amount
B -> Amount
C -> Amount
D -> Amount
E -> Amount
F -> Amount

Tab 2: Month 1
Tab 3: Month 2
Tab 4: etc...

Under month 1 tab...
I want to achieve..
If drop down list "A" is selected, amount entered into cell will be updated on Summary A -> Amount cell.
If drop down list "C" is selected, amount entered into cell will be updated on Summary C -> Amount cell.

This amount cell is like a sum total of my category.

Anyone knows if it's achiveable?

Untitled.png

[dilipandey]

Hi KeKengps,


SumIF or Sumproduct function can help here.. but can't confirm till the I see a sample workbook... please upload. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>