Using the wildcard * character

E

Edge118

=SUMPRODUCT((Description!$B$1:$B$5000=A2)
(Description!$A$1:$A$5000=$B$1) * (Description!$C$1:$C$5000="2.0"))

Hi I'm using SUMPRODUCT to find matching data within 3 columns. At th
end of the statement above I have ...="2.0")), but what I want it to d
is to match the cells that start with 2.0 and then have anything els
after it. I know I have to use the * character but I am not sure how.
Thanks for your help!

R
 
D

Domenic

Hi,

Try changing the last part to something like this:

Match those starting with 2.0

....*(LEFT(Description!$C$1:$C$5000,3)="2.0"))

If you want to match those containing 2.0 anywhere in the cell

....*(ISNUMBER(FIND("2.0",Description!$C$1:$C$5000))))

Hope this helps!
 
Top