View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
 
Posts: 259
Default Wildcards in SumIF formula

Hi All

Need help with the correct 2K / 2K3 Syntax for the following please..

=SUMIF(Schedule!$K2:$K300, SEARCH(LIKE("DONE *")Schedule!$F2:$F300))

Essentially "K" will have numerous text values, most are consistant, but
there will be some that will have values like "DONE 17/09", and as this file
I am setting up will be the Master Template I need a <Wildcard search to
match as each day will have a different "DONE *Date*"

Appreciate the assist

TIA
Mick.