Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Struggling for a solution
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.:( -- Baz ------------------------------------------------------------------------ Baz's Profile: http://www.excelforum.com/member.php...o&userid=28930 View this thread: http://www.excelforum.com/showthread...hreadid=486732 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Struggling for a solution
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
??SUMPRODUCT? other solution? | Excel Worksheet Functions | |||
Show trial solution | Excel Worksheet Functions | |||
How to deploy an Excel 2003 solution | Excel Discussion (Misc queries) | |||
Generating excel combinations | Excel Discussion (Misc queries) | |||
What is Multiple R, it is the first solution obtained in Regressi. | Excel Worksheet Functions |