HELP Sumif or Sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sheet 1 is a summary sheet that looks like -

Sales Person Commission
1 14 $4,500.00
2 15 $2,580.00
3 16 $1,533.00
4 22 $1,500.00
5 25 $0.00

Sheet 2 looks something like -

Salesperson Product Commission
1 14 GlasBu 1500.00
2 14 GlasBu 1500.00
3 22 ThiHy 1500.00
4 14 GlasBu 1500.00

What I am looking for is a formula for Sheet 1 that looks at A1 and then
looks at Sheet 2 A1 and everytime the numbers match, cumlatively adds the
amount in Sheet 2 C1.

Hope this make sense and I really appreciate your help.
 
Back
Top