View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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"))