Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am looking to count the number of times a value(ie "3") appears in one
column only if the column next to it has a different specific value(ie "bob"). column value1 value2 12 3 tim 13 3 tim 14 2 tim 15 3 bob 16 4 bob 17 3 bob So in this case, it would count 2. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try something like this:
...........A..........B 1........2.........Bob 2........3.........Tim 3........3.........Bob 4........1.........Bob 5........3.........Bob =SUMPRODUCT(--(A1:A5=3),--(B1:B5="Bob")) -- Biff Microsoft Excel MVP "scooter" wrote in message ... I am looking to count the number of times a value(ie "3") appears in one column only if the column next to it has a different specific value(ie "bob"). column value1 value2 12 3 tim 13 3 tim 14 2 tim 15 3 bob 16 4 bob 17 3 bob So in this case, it would count 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
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 1 Numeric value in a Row and Return Count down Column | 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 |