Thanks but this is counting all of the instances of Y when I want to count
the insatances where Y is present in col a AND A is present in colb - both
are independant of on antother
--
John


"Ms-Exl-Learner" wrote:

Put this formula other than A&B Column cell.

=COUNTIF(A:A,"Y")+COUNTIF(B:B,"A")

Remember to Click Yes, if this post helps!

--------------------
(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