Thread: Formula for if name begins with and date is less than or equal to.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Senor Martinez[_2_] Senor Martinez[_2_] is offline
external usenet poster
  
Posts: 7
Default Formula for if name begins with and date is less than or equal to.
Im trying to create a formula that gives me a total count for cells that are
less than 02/05/10 and the name begins with FHLM, on previous post teethless
mama helped me w this, but im still getting a value of 0. Someone please
help!!

=SUMPRODUCT(--(E1:E100<=DATE(2010,2,5)),--(LEFT(U1:U100,4)="FHLM"))


Thanks in advance.

Reply With QuoteReply With Quote