Thread: Array Formula with AND operator
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian edwardpestian is offline
external usenet poster
  
Posts: 1
Default Array Formula with AND operator

Okay, I got it..


Code:
--------------------


=SUM(IF((E16:E39TODAY()-180)*(E16:E39<=TODAY())*(I16:I39<""),(I16:I39),0) )*8


--------------------


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=561957

Reply With QuoteReply With Quote