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!
Bookmarks