please help me to solve this

[stggst]

Please assit me

-- removed inline image ---

if highlighted cell contain jan - mar drop down list.i want to write a formula to get total of "s" of selected month.How can i do it using formula (if highlighted select march answer 15 please help me to solve this

 

[stggst]

Re: Please assit me

if highlighted cell contain jan - mar drop down list.i want to write a formula to get total of "s" of selected month.How can i do it using formula (if highlighted select march answer 15 please help me to solve this


-- removed inline image ---

 

[SteveO59L]

Re: Please assit me

try posting a sample of your data, and what you would like to do with it

 

[stggst]

if highlighted cell contain jan - mar drop down list.i want to write a formula to get total of "s" of selected month.How can i do it using formula (if highlighted cell select a march answer 15) please help me to solve this

January
Product	January	February	March
s	1	2	9
f	4	7	2
s	8	8	6
c	8	5	7

<tbody>
</tbody>

 

[stggst]

Re: Please assit me

if highlighted cell contain jan - mar drop down list.i want to write a formula to get total of "s" of selected month.How can i do it using formula (if highlighted cell select a march answer 15) please help me to solve this

January
Product	January	February	March
s	1	2	9
f	4	7	2
s	8	8	6
c	8	5	7

<tbody>
</tbody>

 

[FormR]

Re: Please assit me

Try:

Excel 2012
	A	B	C	D	E	F
1	March
2	Product	January	February	March		15
3	s	1	2	9
4	f	4	7	2
5	s	8	8	6
6	c	8	5	7
Sheet1

Cell Formulas
Range	Formula
F2	=SUMIF(A3:A6,"S",INDEX(B3:D6,0,MATCH(A1,B2:D2,0)))

 

[stggst]

Re: Please assit me

Thanks for your reply.if i want to get YTD(year to date) values can we develop this? (If i select march ans is 34) sum of "s" January to selected month(March/February)

 

[FormR]

Re: Please assit me

Thanks for your reply.

No problem, nice to hear it helped.

if i want to get YTD(year to date) values can we develop this? (If i select march ans is 34) sum of "s" January to selected month(March/February)

Here are two options, one uses a helper column, the other is standalone.

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Apr
2	Product	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	YTD
3	s	1	2	9	2	2	2	2	2	2	2	2	2	14	< YTD Helper Column
4	f	4	7	2	7	7	7	7	7	7	7	7	7	20
5	s	8	8	6	8	8	8	8	8	8	8	8	8	30
6	c	8	5	7	5	5	5	5	5	5	5	5	5	25
7
8														44	< Using YTD Helper Column
9														44	< Stand alone
Sheet1

Cell Formulas
Range	Formula
N3	=SUM(B3:INDEX(B3:M3,MATCH($A$1,B$2:M$2,0)))
N8	=SUMIF(A3:A6,"s",N3:N6)
N9	=SUMPRODUCT((A3:A6="s")*(B3:INDEX(B3:M6,COUNTA(A3:A6),MATCH(A1,B2:M2,0))))

 

[stggst]

Re: Please assit me

Thank a lot