Calculation Formula Help
Hi all! Here is a snip of the columns on a separate sheet that I am referencing in my formula:
I need to count how many times a survey is completed each month in each area. I have a total submissions section where the total number of submissions is a rolling count, but I need to drill that down to show, for instance, how many times A2 completed a survey in January 2023. I thought I could use a sum or count formula, but I can't make it work in my head.
Help Article Resources
Check out the Formula Handbook template!