wildcards

[robert f callaghan]

Greetings everyone

I\'m trying to use wild cards inside an array.
Column F contains error codes 1.1, 1.2. 1.3 etc
Column I contains dates in April; 2.04.07, 5.04.07 etc...
I tried this: but it doesnt work
sum{(F3:F500=\"1*\")*(I3:I500=\"*4*\")}
I also tried it with sumproduct and no array but still no luck.
Any idea how to get the desired affect?
thanks a lot
Cookie boy

 

[Sandy Mann]

Try:

=SUMPRODUCT((LEFT(F1:F25,2)="1.")*(MID(I1:I25,LEN(I1:I25)-4,2)="04"))

2.04.07 is not a date unless your date separator is a period. If that is
the case then you can use:

=SUMPRODUCT((LEFT(F1:F25,2)="1.")*(MONTH(I1:I25)=4))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk