LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default CountIf value

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use a countif function according to two other countif fu. Kirsty Excel Worksheet Functions 2 February 20th 06 11:44 AM
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") sctroy Excel Discussion (Misc queries) 2 September 25th 05 04:13 AM
COUNTIF or not to COUNTIF on a range in another sheet Ellie Excel Worksheet Functions 4 September 15th 05 10:06 PM
COUNTIF Zachary Turner Excel Discussion (Misc queries) 3 May 28th 05 10:11 PM
COUNTIF in one colum then COUNTIF in another...??? JonnieP Excel Worksheet Functions 3 February 22nd 05 02:55 PM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"