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