S
Scott@CW
I need to see if there is an easier or shorter way to write this formula
=SUMPRODUCT((TERMS!$L$2:$L$18985="2110220821")*(TERMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985="4.
Better Job /
Pay")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"}))+SUMPRODUCT((TERMS!$L$2:$L$18985="2110220820")*(TERMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985="4.
Better Job /
Pay")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"}))+SUMPRODUCT((TERMS!$L$2:$L$18985="2110220819")*(TERMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985="4.
Better Job /
Pay")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"}))
=SUMPRODUCT((TERMS!$L$2:$L$18985="2110220821")*(TERMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985="4.
Better Job /
Pay")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"}))+SUMPRODUCT((TERMS!$L$2:$L$18985="2110220820")*(TERMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985="4.
Better Job /
Pay")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"}))+SUMPRODUCT((TERMS!$L$2:$L$18985="2110220819")*(TERMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985="4.
Better Job /
Pay")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07","OCT07","NOV07","DEC07"}))