I need to use either sumif or match or whatever using multiple criteria. The
data is on 2 different worksheets.
Each sheet has 4 columns of data: Name, Company, Date, Charge
Because of the sheet layout, I'm not using lables
I need to search the second sheet and add the charges of every row that
matches the Name, Company and Date for each line on the first sheet.
Example: First Sheet
| Name | Company | Date | Charge |
| Joe | Shop | Mar 3 | $100.00 |
| Bill | Office | Mar 3 | $50.00 |
| Tom | Shop | Dec 6 | $100.00 |
Second Sheet
| Joe | Shop | Mar 3 | $25.00 |
| Bill | Office | Dec 6 | $50.00 |
| Joe | Shop | Mar 3 | $75.00 |
| Tom | Shop | Dec 6 | $100.00 |
For the first row of the first sheet, the search will add the charges from
rows 1 & 3 on the second sheet because the first three values match.

Any ideas out there?