View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
charles charles is offline
external usenet poster
 
Posts: 124
Default wild cards in SUMIF

Wild cards do not work in SUMIF. =SUMIF(J:J,"10/*/2006",D:D) gives me zero
while =SUMIF(J:J,"10/13/2006",D:D) gives me a correct sum.