=SUMPRODUCT(--(A1:A10="Amy"),--(B1:B10="Closed"))
You can also put 'Amy' and 'Closed' in two cells, say C1 and C2
=SUMPRODUCT(--(A1:A10=C1),--(B1:B10=C2))
Regards,
Alan.
"TJ" wrote in message
...
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