helpfile1a.xlsx

Hello,
i am looking for some Help with this Spreadsheet i am creating please.

the Basic's is i have a sheet called "paperwork" and its a table with all the data at the moment and another called "yearly view by date", what i want this one to do is count how many times a Racf has appeared in the "paperwork" sheet and Ive managed this, but what i also need the "yearly view by date" sheet to do is count how many responses each Racf has provided as well.

i have no idea how to make this happen ???

So any help would be appreciated.
i have attached a copy for anyone would like to have ago.

Thank you

Kind Regards

Chris

(p.s i had to change the names on the sheets due to data protection)