CountIf value

[bob]

The worksheet "Chart 3" has various combinations of names listed in columns H
and I, and numbers listed in columns N and O, as shown below. The worksheet
has values in these columns for rows 2 through 2000.

COL H COL I COL N COL O
name1 name2 0 1
name3 name1 1 0
name4 name3 1 1
name3 name5 1 0
name1 name2 0 1

From the worksheet "James," I want to calculate how many times each
combination of names is listed. In the above example, name1 and name2 are
listed twice.

Also from worksheet "James," I want to add the numbers in column N for each
combination and, separately, also add the numbers in column O for each
combination.

Thanks,
Bob

 

[ryguy7272]

Try experimenting with a Pivot Table. A Pivot Table will do this for you,
and a whole lot more too...
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html

Regards,
Ryan---

 

[bob]

sorry, but a pivot table is not an option in this case for various reasons. I
need a formula that will provide the correct results.

Bob

 

[ryguy7272]

=SUMPRODUCT(--(I1:I5="name2"))

Take a look at this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards,
Ryan---