sum if

[Guest]

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.

 

[Rowan]

Assume original data in Columns A-E, with names in column A. The values
you want to check to be 1 are in column B and the value to sum is in
column C.
You unique list of names is in column H starting in row1. In I1 enter
the formula:
=SUMPRODUCT(--($A$1:$A$300=H1),--($B$1:$B$300=1),$C$1:$C$300)
and copy down.
You will need to edit so that it picks up all the rows in your data but
you can't use an entire column.

Hope this helps
Rowan