PivotTable or SumProduct function to break out values

Im sure this is real simple using a pivot, sumproduct, or countIf function.
I have a table with records that have repeating names in numerous rows (Bob, Jill, Mike). Each have responsibilities for during four party- these responsibilities are on the horizontal axis.
I want output to count the values for each person per party responsible: example: Mike is responsible for FOOD 3 times and not responsible for it once.
This is basically a pivot with the values broken out since the values are binary.
See attached. Its a lot more clear

thanks

is there a way to do it using sumProduct or some IF conditional? Changing the table format is not an option for this particular problem