| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count values in a range of cells depending on value in adjacent ce
I have a spreadsheet with names in column A and names are often repeated
within this column. Columns B - E have values. I want to count the valuies in each column only if the name in the row is ""Bob"? I also sometimes want to count the values in each column if the name is "Bob" or "Dave"? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count values in a range of cells depending on value in adjacent ce
Columns B - E have values.
values = numbers? Try these: =SUMPRODUCT((A1:A10="Bob")*(ISNUMBER(B1:E10))) =SUMPRODUCT(((A1:A10="Bob")+(A1:A10="Dave"))*(ISNU MBER(B1:E10))) Better to use cells to hold the criteria: G1 = Bob H1 = Dave =SUMPRODUCT((A1:A10=G1)*(ISNUMBER(B1:E10))) =SUMPRODUCT(((A1:A10=G1)+(A1:A10=H1))*(ISNUMBER(B1 :E10))) -- Biff Microsoft Excel MVP "birdgirl31" wrote in message ... I have a spreadsheet with names in column A and names are often repeated within this column. Columns B - E have values. I want to count the valuies in each column only if the name in the row is ""Bob"? I also sometimes want to count the values in each column if the name is "Bob" or "Dave"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count values in a range of cells | Excel Worksheet Functions | |||
| how do i count cells with values in a certain range ? | Excel Discussion (Misc queries) | |||
| How to count several non-adjacent cells | Excel Worksheet Functions | |||
| Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
| Is there an easy way to count when adjacent cells contain same data? | Excel Worksheet Functions | |||
Hybrid Mode
