is there a function that will allow you to sumif based on four criteria
across two separate worksheets?

i have a sales rep id with a start and end date on one worksheet and order
information (which includes sales rep id, order date, and order type).

i want to be able to sum the orders for each sales rep provided that
1. the sales ids match AND
2. the order date is greater than the rep's start date AND
3. the order date is less than the rep's end date
4. for a specific order type

rep id is in column a on both sheets,
start date is in column b of workbook1,
end date is in column c of workbook1,
order date is in column b of workbook2,
order type is in column c of workbook2