COUNTIF/SUM(IF/SUMIF/COUNTIFS?

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

@Kelzysned 

In H2:

 

=COUNTIFS($A$2:$A$9,E2,$C$2:$C$9,"<>")+COUNTIFS($B$2:$B$9,E2,$C$2:$C$9,"<>")

 

or

 

=SUMPRODUCT(($A$2:$B$9=E2)*($C$2:$C$9<>""))

 

Fill down