sum values selected variance in the list

[jeditetsu]

Dear mrexcel community,
My questions is;

	Jan	Feb	Mar	Apr
Item 1	10	20	40	10
Item 2	20	20	30	10

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

Suppose there is a dropdown menu for item 1 and 2.
When selected 1 I want to sum all the months.
What is the shortest way of doing it?

thanks a lot!
tim

 

[Marcílio_Lobão]

jeditetsu, Good morning.

Supposing your scenario, try to use this formula at H2

	A	B	C	D	E	F	G	H
1		Jan	Feb	Mar	Apr
2	ITEM 1	10	20	40	10		ITEM 1	=SUMPRODUCT((A2:A3=G2)*(B2:E3))
3	ITEM 2	20	20	30	100

<tbody>
</tbody>

Please, tell us if it worked as you desire.
I hope it helps.

 

[jeditetsu]

hello Marcilio,

Exactly, just the formula I needed!
thank you very much and hope you`ll have a beautiful day.

best regards
timur