Sumifs
 

Hi,
I tried to do a sumifs for my simple spreadsheet but could make it works. I
have a table with EmpID column, Plan elem, and the weighted avg %, I want to
sum the weighted avg % for all the plan elem = 1 per empID. Note that one
emp have multiple plan elems. Please help...Thanks, MyLan

EmpID Plan Elem weighted avg%
1 1 20
1 2 10
1 3 10
1 1 50
2 1 30
2 2 20
2 3 10
3 1 60
3 2 20
3 3 10
3 1 10
3 1 20

Sumifs
 

Try

=SUMIFS(C:C,A:A,1,B:B,1)

=SUMIFS(C:C,A:A,2,B:B,1)

etc.

--

HTH

Bob

"MyLan" wrote in message
...
Hi,
I tried to do a sumifs for my simple spreadsheet but could make it works.
I
have a table with EmpID column, Plan elem, and the weighted avg %, I want
to
sum the weighted avg % for all the plan elem = 1 per empID. Note that one
emp have multiple plan elems. Please help...Thanks, MyLan

EmpID Plan Elem weighted avg%
1 1 20
1 2 10
1 3 10
1 1 50
2 1 30
2 2 20
2 3 10
3 1 60
3 2 20
3 3 10
3 1 10
3 1 20

Sumifs
 

Is that what you have in mind ?
http://img130.imageshack.us/img130/1420/nonamepi.png
Micky


"MyLan" wrote:

Hi,
I tried to do a sumifs for my simple spreadsheet but could make it works. I
have a table with EmpID column, Plan elem, and the weighted avg %, I want to
sum the weighted avg % for all the plan elem = 1 per empID. Note that one
emp have multiple plan elems. Please help...Thanks, MyLan

EmpID Plan Elem weighted avg%
1 1 20
1 2 10
1 3 10
1 1 50
2 1 30
2 2 20
2 3 10
3 1 60
3 2 20
3 3 10
3 1 10
3 1 20