|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
June 4th, 2010, 04:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting question
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 
|
|
#2
June 4th, 2010, 04:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
=COUNTIFS(A:A,"Y",B:B,"A")
Regards Steve "John" wrote in message ... 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
|
|
#3
June 4th, 2010, 04:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
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
|
|
#4
June 4th, 2010, 04:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
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
|
|
#5
June 4th, 2010, 04:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
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
|
|
#6
June 4th, 2010, 05:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
Thanks but this is counting all of the instances of Y when I want to count
the insatances where Y is present in col a AND A is present in colb - both are independant of on antother -- 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
|
|
#7
June 4th, 2010, 05:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
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
|
|
#8
June 4th, 2010, 05:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
Check the reply posted by Mike Sir. It will get the result which you are
expecting to do. -------------------- (Ms-Exl-Learner) -------------------- "John" wrote: Thanks but this is counting all of the instances of Y when I want to count the insatances where Y is present in col a AND A is present in colb - both are independant of on antother -- 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
|
|
#9
June 4th, 2010, 05:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
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
|
|
#10
June 4th, 2010, 05:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting question
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
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
