Hi Group,
I am having trouble with a sumproduct formula.
=SUMPRODUCT(--(L2:L33331=B7),--(L2:L33331<=B9),--
(D2:D33331="EQUIPMENT")*OR
(P2:P33331="COMPLETE1",P2:P33331="COMPLETE2",P2:P3 3331="COMPLETE3",P2:P33331="COMPLETE4"))
B7 and B9 are my inclusive dates, checked against Col L, and I want to
count the number of "EQUIPMENT" that are any of the 4 "COMPLETES".
This works very well if I only have 1 type of "EQUIPMENT", but even
then I'm not certain if that's the correct way to do that. My problem
arises when I want more than 1 "EQUIPMENT" , such as
"EQUIPMENT1","EQUIPMENT2","EQUIPMENT3","EQUIPMENT4 ". Is there a way to
do what I'm asking? Any help will be very much appreciated!
Ken