Hi,
i know i need to use a sumproduct for this kind of problem, and i have copied the formula (2 conditions) from another spreadsheet where it is working fine, but it doesnt seem to be working when i increase the number of conditions.
I have 4 columns:
A - Name
B - Job Type
C - Quantity
D - Date
i have specified the name of the worker in cell A1, the start date in cell B1, finish date in cell C1 and job type in D1, and i want to sum up the quantity of work that individual did between the two dates for a specific job type
so there's 4 conditions, name, date is greater than start date, date is less than end date, plus job type
can you give me a hand, this is what i have so far
=SUMPRODUCT(--($A$3:$A$3500=$A$1),--(D$3:$D$3500>=$B$1,($E$3:$E$3500<=$C$1),--($B$2:$B$3500=$D$1),($C$3:$C$3500))
i know i need to use a sumproduct for this kind of problem, and i have copied the formula (2 conditions) from another spreadsheet where it is working fine, but it doesnt seem to be working when i increase the number of conditions.
I have 4 columns:
A - Name
B - Job Type
C - Quantity
D - Date
i have specified the name of the worker in cell A1, the start date in cell B1, finish date in cell C1 and job type in D1, and i want to sum up the quantity of work that individual did between the two dates for a specific job type
so there's 4 conditions, name, date is greater than start date, date is less than end date, plus job type
can you give me a hand, this is what i have so far
=SUMPRODUCT(--($A$3:$A$3500=$A$1),--(D$3:$D$3500>=$B$1,($E$3:$E$3500<=$C$1),--($B$2:$B$3500=$D$1),($C$3:$C$3500))