Thread: "if" function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
raf
 
Posts: n/a
Default "if" function
Hi Bob,
Thanks for the formula! It works great, just what I needed.


"Bob Phillips" wrote:

=SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1),C2:C5)
Reply With QuoteReply With Quote