View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default HELP Sumif or Sumproduct

On Sheet1:

=SUMIF(Sheet2!$A$2:$A$50,A2,Sheet2!$C$2:$C$50)

HTH

"Cathy" wrote:

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.