Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WildCards in Sumif Function | Excel Worksheet Functions | |||
sumif and wildcards | Excel Worksheet Functions | |||
Wildcards in SUMIF Function | Excel Worksheet Functions | |||
Problems with SUMIF function and Wildcards (* and ?) | Excel Worksheet Functions | |||
wildcards with sumif/countif in macro/vba | Excel Programming |