CountIF or SumIF

S

Scott@CW

I need a formula that will first look in column A for a name, then look in
column b and count how many times a certain value appears for that name.
ColumnA Column B
Scott Agree
John Agree
Scott Agree
How many times does scott have a agree?
Answer:
2
 
T

T. Valko

Try this:

=SUMPRODUCT(--(A1:A10="Scott"),--(B1:B10="Agree"))

Better to use cells to hold the criteria:

C1 = Scott
D1 = Agree

=SUMPRODUCT(--(A1:A10=C1),--(B1:B10=D1))

Note: you can't use entire columns as range references - A:A, B:B (unless
you're using Excel 2007)

Biff
 
Top