Recent content by Timothy1721

Wow! I plugged it in and it did exactly what I was looking for. I never in a million years would have figured that out on my own. Thanks so much!!

Hey Sir JB7....As as follow up I plugged in the formula you suggested, and it does work for AAA! I tried it on the AAB and it did not work. Sorry for being such a rookie at this, but your help is really appreciated.

Thanks Sir JB7! I think I can make this work. I should have mentioned that I do want to do this for the other classes as well "AAB","ABB", etc. Would I use the same formula and just sub in the AAB or ABB? I did have another question in regards to the formula. I know that C3:C is the range...

No, I want to count the "Yes" but only in the top 4 AAA results. I know that I can select a range to do this (=COUNTIF(E3:E6,"yes")will work, but If I want to count only the top 3 AAA that have "yes" for the next drawing, this method won't work because it will count the top 4. I have cell...

Hello Fasheeh! Thanks for the Welcome! It looks like the "pulls" didn't copy over properly when I was posted this. I've included it below. The "No" or the "Yes" in the pulls column is determining if it matched a pulled number. For example, if the number 46 was pulled from a hat a "Yes" will...

I've looked thought this forum and I'm couldn't find what I was looking to do any where, though I may have missed it. On the below chart I want to count the "Yes" data in the first four "pulls" rows. I know can do this with a countif, however, the data changes routinely and is automatically...