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.

Wildcards in SumIF formula
 

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