Richard Detwiler wrote:
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
I am trying to do something that doesn't seem all that difficult,
but I can't figure it out.
I have two columns, let's say column A and column B. Cells in
Column A contain a single letter, "A", "B", or "C". Cells in column
B also contain a single letter, "Y" or "N". There are several
hundred rows of data.
I know I can use COUNTIF to count all of the "Y's" in column B.
What I would like to do is count all of the instances where Column A
is an "A" and Column B is "Y". (Then do the same for the other
combinations of letters, but I do the extrapolation once I figure
out how to do it with "A" and "Y".)
I can think of some in-elegant ways of doing it, like sorting by
column A, putting all of the rows with "A" into a separate sheet,
etc., but I'd like to avoid that level of data manipulation if I could.
Any suggestions would be apprectiated; thanks.
Try SUMPRODUCT. e.g. =SUMPRODUCT($A$1:$A$26="A";$B$1:$B$26="Y")
That did it! Thanks very much, I had never had reason to utilize this
function before (and I am sure I wouldn't have discovered it on my own).
You're welcome. I did not realise you were the OP; otherwise, I would
have replied to your later message. :-(
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
