I have a list of data, about 5 columns and many many rows down.

I used a Advance filter to get a unique list of the Names listed in one of
the columns.

I'm tring to write a formula next to the filtered unique list that looks up
the name in each row and then goes back to the larger list and sums the
matching entries in one column if the column the unique list was created on
equals the criteria.

I used the sumif and was able to do this. My problem is that I really need
two sets of criteria. For example if one row the name is Mary and a another
column on the same row is = to 1. I need the criterias to be cell references.

Any help will be greatly appreciated.