Hi,

I want to count the instances of A in col b when there is a Y in
col a

That is exactly what my formula does and if it isn't working then my guess
is you entered it incorrectly

This for example will return #NA because the ranges are different sizes
=SUMPRODUCT((A1:A20="Y")*(B1:B21="A"))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"John" wrote:

Thanks but I get #N/A the variables in col a and b are independant of one
another and I want to count the instances of A in col b when there is a Y in
col a both can occur in a range of rows like row 1:200
--
John


"Mike H" wrote:

John.

try this

=SUMPRODUCT((A1:A20="Y")*(B1:B20="A"))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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

That's it - THANK A BIG BUNCH
--
John


"Mike H" wrote:

Hi,

I want to count the instances of A in col b when there is a Y in
col a

That is exactly what my formula does and if it isn't working then my guess
is you entered it incorrectly

This for example will return #NA because the ranges are different sizes
=SUMPRODUCT((A1:A20="Y")*(B1:B21="A"))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"John" wrote:

Thanks but I get #N/A the variables in col a and b are independant of one
another and I want to count the instances of A in col b when there is a Y in
col a both can occur in a range of rows like row 1:200
--
John


"Mike H" wrote:

John.

try this

=SUMPRODUCT((A1:A20="Y")*(B1:B20="A"))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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