help in Sumiff if we have same data in a column

[sksanjeev786]

Hi Team

I nee a sum of score based on A1 to 13 (some role are replitative ) so need total on A16

book1
	A	B	C	D	E	F
1	Role	Description	03/03	03/04	03/05	03/06
2	R003	Senior Project Manager UK	7.29	1.89	0.86
3	R008	Service Manager UK	6.21	4.18	5.07	2.29
4	R013	Project Manager UK	25.25	10.00	-2.36	2.86
5	R114	CFS Systems Analyst - Dev UK	1.43	3.29	2.86
6	R120	CFS Analyst Programmer - Dev UK				7.21
7	R188	Senior Project Manager UK	0.64	0.64	5.93	0.79
8	R003	Senior Project Manager UK	-9.00	-1.43		-0.36
9	R013	Project Manager UK	23.89	-6.29	32.50	20.61
10	R017	Solution Architect UK	45.00	28.79	-0.96	32.07
11	R114	CFS Systems Analyst - Dev UK			2.57	23.61
12	R120	CFS Analyst Programmer - Dev UK
13	R188	Senior Project Manager UK	1.57	1.86	3.04	-0.57
14
15		03/03	03/04	03/05	03/06
16	R003
17	R008
18	R013
19	R017
20	R114
21	R120
22	R188
23
Sheet4

 

[Marcílio_Lobão]

sksanjeev786,

Try to use:

B16 -->

=SUMIF($A$2:$A$13, $A16, C$2:C$13)

Drag down and to the sides the formula

Please let us know if it worked as you wanted.

Hope this helps.

 

[sksanjeev786]

sksanjeev786,

Try to use:

B16 -->

=SUMIF($A$2:$A$13, $A16, C$2:C$13)

Drag down and to the sides the formula

Please let us know if it worked as you wanted.

Hope this helps.

Hi

Thank you so much

Can i get via Indirect funtion i have data in "data1" tab

 

[Marcílio_Lobão]

sksanjeev786,

If you have the same layout in the data1 tab, simply add the term data1! in the formula:

B16 -->

=SUMIF(data1!$A$2:$A$13, $A16, data1!C$2:C$13)

Drag down and to the sides the formula

Was this what you needed?

Hope this helps.

 

[sksanjeev786]

sksanjeev786,

If you have the same layout in the data1 tab, simply add the term data1! in the formula:

B16 -->

=SUMIF(data1!$A$2:$A$13, $A16, data1!C$2:C$13)

Drag down and to the sides the formula

Was this what you needed?

Hope this helps.

thank you so much Team

 

[Marcílio_Lobão]

sksanjeev786,

I'm glad to help you and thanks for the feedback!

Have a nice day.