Column G=Employ Number (G88:G15999)
Column C= Month
Column D = Equipment Type either A,B, or C
Column Q = $ Sum of equipment sold
I want to Sum the Sales of model "A, B, or C' equipment sold in each month by employee number.
My formula =SUMPRODUCT(--($G$88:$G$15999=$C16),--($D88:$D15999= A or B or C),--($C88:$C15999>=Month Start),--($C88:$C15999<=<Month End),$Q$88:Q$15999
My issue is the second item and wanting it to search for A or B or C and in any one of those cases sum the total in Q88:Q15999 if all the other criteria are met as well.