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
|