| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if
Hi,
I am trying to count the number of individuals in two seperate columns on the same spreadsheet: For exemple, in my column A, some cells have "Robert" and in Column B, some cells have "Robert". I want to know how many times we have "Robert" side by side. Cell A1 = Robert and Cell B1 = Robert I dont want to count all the other cells where Robert is shown but not beside another Robert Many Thanks Robert |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
Hi,
try =SUMPRODUCT(--(A2:A6="Robert")*(B2:B6="Robert")) change range to fit your needs "Robert" wrote: Hi, I am trying to count the number of individuals in two seperate columns on the same spreadsheet: For exemple, in my column A, some cells have "Robert" and in Column B, some cells have "Robert". I want to know how many times we have "Robert" side by side. Cell A1 = Robert and Cell B1 = Robert I dont want to count all the other cells where Robert is shown but not beside another Robert Many Thanks Robert |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
=SUMPRODUCT((A1:A100="Robert") * (B1:B100="Robert"))
-- Gary''s Student - gsnu200907 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
=SUMPRODUCT((A1:A21="robert")*(B1:B21="robert"))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Robert" wrote in message ... Hi, I am trying to count the number of individuals in two seperate columns on the same spreadsheet: For exemple, in my column A, some cells have "Robert" and in Column B, some cells have "Robert". I want to know how many times we have "Robert" side by side. Cell A1 = Robert and Cell B1 = Robert I dont want to count all the other cells where Robert is shown but not beside another Robert Many Thanks Robert |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
What is the double unary minus doing for you in this situation, Eduardo?
Isn't --1 the same as 1, and --0 the same as 0? -- David Biddulph "Eduardo" wrote in message ... Hi, try =SUMPRODUCT(--(A2:A6="Robert")*(B2:B6="Robert")) change range to fit your needs "Robert" wrote: Hi, I am trying to count the number of individuals in two seperate columns on the same spreadsheet: For exemple, in my column A, some cells have "Robert" and in Column B, some cells have "Robert". I want to know how many times we have "Robert" side by side. Cell A1 = Robert and Cell B1 = Robert I dont want to count all the other cells where Robert is shown but not beside another Robert Many Thanks Robert |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if
Hi David,
you are right, I was in excel and just enter the double unary, isn't doing anything "David Biddulph" wrote: What is the double unary minus doing for you in this situation, Eduardo? Isn't --1 the same as 1, and --0 the same as 0? -- David Biddulph "Eduardo" wrote in message ... Hi, try =SUMPRODUCT(--(A2:A6="Robert")*(B2:B6="Robert")) change range to fit your needs "Robert" wrote: Hi, I am trying to count the number of individuals in two seperate columns on the same spreadsheet: For exemple, in my column A, some cells have "Robert" and in Column B, some cells have "Robert". I want to know how many times we have "Robert" side by side. Cell A1 = Robert and Cell B1 = Robert I dont want to count all the other cells where Robert is shown but not beside another Robert Many Thanks Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
