B
Bruce
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
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