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

Asked By birdgirl3 on 17-Nov-08 06:41 PM
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

T. Valko replied on 17-Nov-08 06:55 PM
values = numbers?

Try these:



Better to use cells to hold the criteria:

G1 = Bob
H1 = Dave



Microsoft Excel MVP