Hi
I have a spreadsheet which has 2 columns. Col A contains names and col b
contains either Open or Closed. I want to count the number of closed for
each name. E.g

Amy Open
Amy Closed
Amy Open
Steve Closed
Steve Closed

would give

Amy 1
Steve 2

I can count the names if a countif and the number of closed using countif -
I now want to CountIf(A1:A10,"=Amy") AND CountIf(B1:B10,"=Closed")
Any help please
TJ