Hi Fred,

Can you please help me how to apply the function "sumproduct" inorder to get
this result.

Thanks,
Ajay
"Fred Smith" wrote:

You can't use sumif for more than one condition. Your choices are a Pivot Table,
or Sumproduct. If you need more help, post back with specifics on what you want
to do.

--
Regards,
Fred


"ajay" wrote in message
...
Hi,

I want find out summary with sumif formula for the following datas:
1 A1 B1 C1 D1 E1
2 STAFF # DEP SAL OT ALOW
3
4 101 SALES $400 $75 $200
5 102 ACCT $500 $100 $250
6 103 ADMIN $350 $50 $100
7 104 PUR $350 $- $150
8 105 ACCT $450 $- $150
9 106 ADMIN $300 $75 $125
10 107 PUR $400 $100 $150
11
12 SUMMARY:
13
14 ALOW ACCT ?
15 OT ACCT ?
16 SAL ACCT ?
17 ALOW ADMIN ?
18 OT ADMIN ?
19 SAL ADMIN ?
20 ALOW PUR ?
21 OT PUR ?
22 SAL PUR ?
23 ALOW SALES ?
24 OT SALES ?
25 SAL SALES ?

Thanks