Prev: Need Macro- Insert rows based on dates and copy info from that row
Next: Total percentages
From: MyLan on 6 Apr 2010 14:35
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
From: Bob Phillips on 6 Apr 2010 14:56
Try

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

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

etc.

--

HTH

Bob

"MyLan" <MyLan(a)discussions.microsoft.com> wrote in message
news:B9FEEAC1-E7BB-4602-8C84-694AE488C1D0(a)microsoft.com...
> 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


From: מיכאל (מיקי) אבידן on 6 Apr 2010 15:34
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
 | 
Pages: 1
Prev: Need Macro- Insert rows based on dates and copy info from that row
Next: Total percentages