Prev: Countif QuestionNext: Multiple IF's with an OR From: John on 4 Jun 2010 11:43 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 From: steve on 4 Jun 2010 11:50 =COUNTIFS(A:A,"Y",B:B,"A") Regards Steve "John" wrote in message news:62A26E1C-E421-41E6-834C-B8547707E2D4(a)microsoft.com...> 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 From: Ms-Exl-Learner on 4 Jun 2010 11:53 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 From: Mike H on 4 Jun 2010 11:53 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 From: Ms-Exl-Learner on 4 Jun 2010 11:57 Please Ignore my post, since I have not read it properly. -------------------- (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  |  Next  |  Last Pages: 1 2 3 4 Prev: Countif QuestionNext: Multiple IF's with an OR