CountIF or SumIF
 

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

CountIF or SumIF
 

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

"Scott@CW" wrote in message
...
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

CountIF or SumIF
 

This worked great. How would I add a third variable? I would like to input a
month to search by as well.

"T. Valko" wrote:

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

"Scott@CW" wrote in message
...
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

CountIF or SumIF
 

Try:
=SUMPRODUCT(--(A1:A10="Scott"),--(B1:B10="Agree"),--(MONTH(C1:C10)=10))

Where you want October (Month = 10)


"Scott@CW" wrote in message
:

This worked great. How would I add a third variable? I would like to input a
month to search by as well.

"T. Valko" wrote:

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

"Scott@CW" wrote in message
...
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