Occasional Visitor

I have tried several different formulas and I just cannot figure out what I need to use. I have been googling for hours and hope someone can help. I am trying to monitor work being completed and have managed to figure out formulas for the right hand side table for all except the last column. I want to be able to count how many projects each person has worked on are completed so I need it to say that if their name appears in column A or B and that row has a date in Column C then that counts as 1. Anyone know? 


I have made dummy version of my main spreadsheet to attach so I could create false names. 



1 Reply


In H2:








Fill down