| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use * wildcard in a sum(if((cond),range)) array formula
Hi,
Can anyone tell me howcome the * wildcard does not work in my sum if array formula. I realise that it will work with the standard SUMIF function but I need to use the array version because I will be adding more conditions to what is below. =SUM(IF(('F1'!$C$7:$C$1000="*wedge*"),'F1'!$U$7:$U $1000)) Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| Array Formula to Pick Average | Excel Discussion (Misc queries) | |||
| Question regarding wildcard in multi-criteria IF formula | Excel Worksheet Functions | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Threaded Mode
