Counting question
I get the following message in the cell "The formula contains unrecognized
text"
--
John
"steve" wrote:
=COUNTIFS(A:A,"Y",B:B,"A")
Regards
Steve
"John" wrote in message
...
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
.
|