The formula below works, I was just wondering there is a shorter way of
writing it.

=SUMPRODUCT((TERMS!$L$2:$L$18985="3000080600")*(TE RMS!$R$2:$R$18985="Resigned")*(TERMS!$S$2:$S$18985 ="9.
Personal /
Other")*(TERMS!$I$2:$I$18985={"JAN07","FEB07","MAR 07","APR07","MAY07","JUN07","JUL07","AUG07","SEP07 ","OCT07","NOV07","DEC07"})+SUMPRODUCT((TERMS!$L$2 :$L$18985="3000080600")*(TERMS!$R$2:$R$18985="Resi gned")*(TERMS!$S$2:$S$18985="12.
Retirement")*(TERMS!$I$2:$I$18985={"JAN07","FEB07" ,"MAR07","APR07","MAY07","JUN07","JUL07","AUG07"," SEP07","OCT07","NOV07","DEC07"})))