| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP Sumif or Sumproduct
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif or Sumproduct | Excel Worksheet Functions | |||
| Sumif or Sumproduct? Maybe neither? | Excel Worksheet Functions | |||
| SUMPRODUCT or SUMIF | Excel Worksheet Functions | |||
| SUMPRODUCT or SUMIF or ... | Excel Worksheet Functions | |||
| sumif vs sumproduct | Excel Worksheet Functions | |||
Linear Mode
