count values in a range of cells depending on value in adjacent ce

B

birdgirl31

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"?
 
T

T. Valko

Columns B - E have values.

values = numbers?

Try these:

=SUMPRODUCT((A1:A10="Bob")*(ISNUMBER(B1:E10)))

=SUMPRODUCT(((A1:A10="Bob")+(A1:A10="Dave"))*(ISNUMBER(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)))
 

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

Similar Threads

Count Unique Values in 1 Column based on Date Range in another Column 28
how to count#cells w/= value in other column and not count blank c 4
How do I count # of cells with same value other column? 4
Count values in column only if value of another column is true 4
Count Max values in a range 6
Count column b if column a equal cell value 7
Correct Count 8
Counting depending on another column 4

Top