View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default Counting question

Please Ignore my post, since I have not read it properly.

--------------------
(Ms-Exl-Learner)
--------------------


"John" wrote:

In column A I have set of characters that are entered into the rows below
(i.e. Y, N, MRO) in column B I have another set of characters that are
entered into the rows below (i.e. A, E, on so on). I want to count the
instances when the rows in Column A contain a Y and the rows in column B
contain an A. Is there an simple formula for doing this? Any help will be
appreciated.
--
John