Counting question
in [Functions]
|
Prev: Countif Question
Next: Multiple IF's with an OR
From: Mike H on 4 Jun 2010 12:18 That doesn't work if the AT & Y need to be in the same row which is how you question reads -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "John" wrote: > 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
From: steve on 4 Jun 2010 12:20 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" <John(a)discussions.microsoft.com> wrote in message news:7AF11F58-F373-4B03-8276-EE1FB5460285(a)microsoft.com... >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
From: Ms-Exl-Learner on 4 Jun 2010 12:28 You have to go as per the formula suggested by Mike Sir. -------------------- (Ms-Exl-Learner) -------------------- "John" wrote: > 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
From: John on 4 Jun 2010 12:37 Apparently there is a flaw in what I thought was the solution. i looks like the modified formula is simply counting all instances of "AT" regardless of the presence of any character in col C. I'm still looking for a solution, please. -- John "John" wrote: > 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
From: John on 4 Jun 2010 12:41
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" <John(a)discussions.microsoft.com> 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 > > > . > |