Thread: how to use * wildcard in a sum(if((cond),range)) array formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default how to use * wildcard in a sum(if((cond),range)) array formula
Simple equality relationships do not support wildcards.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bruce" wrote in message
...
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


Reply With QuoteReply With Quote