formula that looks at several worksheets and counts up how often a word is used depending on two different cell texts

[libraryhelp1]

Hi. I am trying to create a formula that looks at several worksheets and counts up how often a word/phrase is used depending on what is inside two different cells. (I am using Excel 365/Windows 10 Pro.)

Basically, across several worksheets, cell C3/D3 (the cell is currently merged but I can separate it if I need to so that it is just cell C3) has a list of word choices (for example, "adult", "child", "family"), and then cell K8 also has a list of word choices (for example, "high school", "college", "graduate school"). [To clarify, these are lists created by using data validation, so they are drop down menu choices and the exact same on every worksheet.] I need to count how many times, when C3 says "adult", cell K8 says "high school" and "college" and "graduate school", and then how often when cell C3 says "child", cell K8 says "high school" and "college" and "graduate school", and then how often when cell C3 says "family", cell K8 says "high school" and "college" and "graduate school."

This is my current formula: =SUMPRODUCT(COUNTIF(INDIRECT("'"&Students&"'!"&"$K$8:$K$8"),C23)) on my summary worksheet where B23 says "adult" and C23 says "high school" [B24 says "adult" and C24 says "college"; B25 says "adult" and C25 says "graduate school"] -> I just can't figure out how to tell it to look at C3 before counting cell K8 on all the worksheets. Otherwise, the formula works and my worksheets are listed and labeled/formatted as a table as Students so it's counting the correct worksheets already.

Thank you.