Pull Specific Values Tied to Names to Two, Separate Columns with Exclusion

I'm trying to automatically calculate tips and manual adjustments for my workplace. Problem is, I'm not too versed with Excel and have spent the better half of today trying to solve it. I have created a sample sheet with some of it already set up. My issue is pulling data from one array and transferring to two separate arrays while including certain instances and excluding others.

I explained it all in the sample worksheet that I attached below.

Thanks so much in advance!

I'm not sure I understand completely, but if you want to add just those values that are "Tips", then add this part to your SUMPRODUCT formula.
($F$11:$F$20="Tip")

Something like this:
=IF(B3>"",SUMPRODUCT(($B$11:$E$20=B3)*($G$11:$G$20)*($F$11:$F$20="Tip")),"")

Hi there, I am also not sure if I am getting the exact understanding on the question, but I think how I have understood your question is that you would like to extracting data from Cells G11:G18 based on names in Cells B11:E18. My recommendation is to CONCATENATE the names into new column first followed up by a SUMIFS formula to compute the tips/other reason for each of the staff. See the changes in Column L to P in red font in the file attached.