I'm creating a pending list spreadsheet

So, I work exporting items to people and I wanted to create a separate table just with pending values separated by person, populated by existing spreadsheets. Is there any way to do this? I'm talking about a formula that searches In some tables for someone's name and the amount they owe (if the checkbox isn't selected), and then sums those values into a single cell