View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Soo Cheon Jheong[_2_] Soo Cheon Jheong[_2_] is offline
external usenet poster
 
Posts: 46
Default help wanted urgent

Daniel,



=SUMPRODUCT(--(A1:A100="00001001"),--(B1:B100=426351),--(C1:C100="cr"),D1:D1
00)


--
Regards,
Soo Cheon Jheong
_ _
^вп^
--