I am trying to create a formula to count the amount of forms returned by a department.
The database is set up in a way as such:
Department Form Recieved?
So Far i have the formula as below:
but after the asterisk i am not sure how i can count the amount of times the date is displayed.
I feel like i have tried everything e.g. COUNTIFS and COUNTAs but to no avail.
Any help is much appreciated!!!