I'm using count if for the master counts of a fantasy football team:
QBs 2 <- =countif($a$3:$a$20,"QB") etc
RBs 5
WR/Tes 6
K 1
Def 2
Total 16

Below shows the columns indicating the bye weeks for that particular player.
Cat Bye

Def 4
QB 5
RB 6
WR 6
QB 6
K 6
WR 6
RB 7
RB 7
RB 8
WR 8
TE 8
WR 8
Def 9
WR 10
RB 10

How can I get the week counts e.g. in week 6 that would show the following
(indicating that in week 6, I'll only have these players available):
e.g. If 6 was entered in a specific cell(F1), then
QBs 1
RBs 4
WR/Tes 4
K 0
Def 2
Total 11
or if 8 was entered in that specific cell(F1), then
QBs 2
RBs 4
WR/Tes 3
K 1
Def 2
Total 12

etc

Thanks,