Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |