Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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"}))
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"