wildcards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robert f callaghan - 04 Sep 2007 13:59 GMT

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

Signature

Via: http://www.jumlers.com/microsoft.public.excel/

Reply to this Message

Sandy Mann - 04 Sep 2007 14:27 GMT

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))

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Greetings everyone
>
[quoted text clipped - 7 lines]
> thanks a lot
> Cookie boy

Reply to this Message