Count Formulas

[CARBOB]

001= 0 hits in 8 draws
002= 1 hit in 8 draws
003= 2 or more hits in 8 draws
The HTML maker would not work. Hope this works.
The values in columns A<B<C<D<E are in column F ranging from 1to 42
Using the criteria above I need count formulas for columns G<H<I<J<K to return those values. All suggestions appreciated.



A B C D E DN
05/12/18 04 10 22 27 33 1
05/11/18 01 11 13 33 37 2
05/10/18 05 09 14 20 31 3
05/09/18 01 07 09 24 37 4
05/08/18 03 05 26 32 39 5
05/07/18 13 17 18 22 38 6
05/06/18 02 05 20 30 42 7
05/05/18 04 06 20 21 25 8
05/04/18 03 06 20 26 37 9
05/03/18 05 13 30 39 41 10

 

[CARBOB]

001= 0 hits in 8 draws
002= 1 hit in 8 draws
003= 2 or more hits in 8 draws
The HTML maker would not work. Hope this works.
The values in columns A<B<C<D<E are in column F ranging from 1to 42
Using the criteria above I need count formulas for columns G<H<I<J<K to return those values. All suggestions appreciated.



A B C D E DN
05/12/18 04 10 22 27 33 1
05/11/18 01 11 13 33 37 2
05/10/18 05 09 14 20 31 3
05/09/18 01 07 09 24 37 4
05/08/18 03 05 26 32 39 5
05/07/18 13 17 18 22 38 6
05/06/18 02 05 20 30 42 7
05/05/18 04 06 20 21 25 8
05/04/18 03 06 20 26 37 9
05/03/18 05 13 30 39 41 10

The values in Col F range from 1 to 42.

 

[CARBOB]

001= 0 hits in 8 draws
002= 1 hit in 8 draws
003= 2 or more hits in 8 draws
The HTML maker would not work. Hope this works.
The values in columns A<B<C<D<E are in column F ranging from 1to 42
Using the criteria above I need count formulas for columns G<H<I<J<K to return those values. All suggestions appreciated.



A B C D E DN
05/12/18 04 10 22 27 33 1
05/11/18 01 11 13 33 37 2
05/10/18 05 09 14 20 31 3
05/09/18 01 07 09 24 37 4
05/08/18 03 05 26 32 39 5
05/07/18 13 17 18 22 38 6
05/06/18 02 05 20 30 42 7
05/05/18 04 06 20 21 25 8
05/04/18 03 06 20 26 37 9
05/03/18 05 13 30 39 41 10

Maybe this will be clearer!
001= 0 hits in 8 draws
002= 1 hit in 8 draws
003= 2 or more hits in 8 draws
The HTML maker would not work. Hope this works.
Using the values in columns B:F and using the criteria above I need count formulas for columns H:L

 

[CARBOB]

Maybe this will be clearer!
001= 0 hits in 8 draws
002= 1 hit in 8 draws
003= 2 or more hits in 8 draws
The HTML maker would not work. Hope this works.
Using the values in columns B:F and using the criteria above I need count formulas for columns H:L

https://app.box.com/s/suk6e9cnrfoajb8sc4fa0nw7kw2nob9l

Finally can post image.
The draws are in $B:$F
Game numbers in $G$10:$G$51
Values in $H$10:$H$51 are the number of times the value hit in 7 draws from the previous. I think those formulas are correct.

What I need is, using the criteria below in columns N:R, need formulas for those values.

001= 0 hits in 8 draws
002= 1 hit in 8 draws
003= 2 or more hits in 8 draws

 

[CARBOB]

Hoping to get a response.
Need formulas for N:R using the values in G:K

https://app.box.com/s/qzh6ec1t2x67s76zh3zvlh1a3zsjr5gf