Struggling for a solution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Baz - 21 Nov 2005 01:02 GMT

Help!

I'm trying to find a formula that would work out this problem:

Column "A" contains either Y or L and column "B" contains T or any
other letter

I need the solution to fprmulate if any cell in column A = Y and any
cell in column B contains T.

Y & T must always be together.:(

Signature

Baz

Reply to this Message

Randall.Senn@excite.com - 21 Nov 2005 02:30 GMT

Baz,

Try a formula along these lines in a cell to generate a value of 0
(there are no rows with both a Y in column A and a T in column B) or
something other than zero (the result giving the count or rows matching
the criteria).

=SUMPRODUCT(--(A$1:A$13="Y"),--(B$1:B$13="T"))

Reply to this Message

Baz - 21 Nov 2005 17:26 GMT

Randall.Senn@excite.com Wrote:

> Baz,
>
[quoted text clipped - 5 lines]
>
> =SUMPRODUCT(--(A$1:A$13="Y"),--(B$1:B$13="T"))

Thanks very much!!!

But now i need to go a step further if column B contains MT, NT1, T et
I need it to count these but exclude if contains NET, AUTO.

Is this possible along the lines of "*T*" but excludes "AUTO" or "NET

:confused

Reply to this Message