What I learned today

This is what I learned today. I was pretty happy as it made my job a lot easier. If it doesn't make sense, don't worry about it. The second one doesn't make 100% sense to me either. I just know it works.

The first formula
=IF((AND(E3>=G3,E3>=I3)),"yes","no")
takes the number in cell E3 and determines if it is greater than or equal to the number in cell G3. It also check if E3 is greater than or equal to the number in cell I3. If E3 is greater than or equal to BOTH of those other numbers, then it writes "yes". If it is not, then it writes "no".

Example:

E3 G3 I3
8 6 7 - yes
5 5 3 - yes
6 7 5 - no



This formula:
=SUM(LEN(A2:A2613)-LEN(SUBSTITUTE(A2:A2613,"yes","")))/LEN("yes")
Is ridiculous. What this formula does, is counts the number of times the word "yes" appears in column A, from cell A2 to cell A2613. So there is 2612 yes or no's down column A. This formula counts the "yes" instances and spits out the total number. In my case, it was 906. That saved me from having to count it myself. The odd thing about this one, the website where I learned this said this second formula is an "array" formula. I don't know what that means. But it said I had to hit ctrl+shift+enter to make it work. Before I hit those three keys, nothing was happening and I got an error. Once I hit them, BAM! 906 comes out.