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 |
#8
|
|||
|
|||
Counting question
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 |
Thread Tools | |
Display Modes | |
|
|