I have a table that is populated using a CountIfs formula. I would like to code this process into VBA without having to write each cell’s formula. I can use WorksheetFunction.CountIfs to automate individual results, but I haven’t been able to code this into a loop. I would like the function to reference the variable in column A (Associate) as well as the Dates in Row 2.