CountIf value


B

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
 
Ad

Advertisements

B

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top