Thread: SUMIF Complicated.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default SUMIF Complicated.
=SUMPRODUCT(--(A2:A64000="2"),--(B2:B64000=DATE(2006, 1,
24)),U2:U64000)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote