Counting question
You asked for a formula looking for "Y" in column A and "A" in column B
And the answer you stumbled on Looks for "AT" in column E and "Y" in column
C
How did we manage to get that one so wrong.
"John" wrote in message
...
I think I stumbled onto the solution using your formula but modifying it to
=COUNTIF(E:E,"AT")+IF(C:C,"Y") I prooved the accuracy of the count by
manually checking.
Thanks
--
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
|