Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott@CW Scott@CW is offline
external usenet poster
 
Posts: 62
Default Formula Help

I need to see if there is an easier or shorter way to write this formula

=SUMPRODUCT((TERMS!$L$2:$L$18985="2110220821")*(TE RMS!$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="Resig ned")*(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="Resig ned")*(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"}))