Thread: Struggling for a solution
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Baz
 
Posts: n/a
Default Struggling for a solution

Wrote:
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"))

Thanks very much!!!

But now i need to go a step further if column B contains MT, NT1, T etc
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"



--
Baz
------------------------------------------------------------------------
Baz's Profile: http://www.excelforum.com/member.php...o&userid=28930
View this thread: http://www.excelforum.com/showthread...hreadid=486732

Reply With QuoteReply With Quote