Counting Multiple Values in a column based on critera in seperate column

Hello!

I have a list of 100+ values that will be listed in column A. I would like to count how many times each value occurs in Column A given that Column F does not contain a value.

I have previously been using the formula =COUNTIFS(A:A, "VALUE NAME", F:F, ""), and that does the job, however, to type that formula for the 100+ values individually is very time consuming.

Additionally, the columns I am counting from are on sheet1 and the list of values that will be used in column A are on a separate worksheet (sheet2) in the same workbook.

I am hoping that there is a simpler way to do it, maybe a macro?

I have attached the workbook for your viewing pleasure, there are other issues I am also working through, so just ignore anything that doesn't seem right.

Many thanks in advance!