Wildcards in SumIF formula

  • Thread starter Thread starter Vacuum Sealed
  • Start date Start date
V

Vacuum Sealed

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.
 
Hi

Lets just forget I posted this and go with the notion one should at least
play with the toys before hitting them with hammers to make them work in
ways their not designed to do....D'oh

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

Cheers
Mick
 
Back
Top