Find number of occurrences for particular person

[Harry Basra]

To simplify it i have 2 columns A & B

A B


Adam Stauber Sold
Adam Stauber Not Sold
Adam Stauber Sold
Adam Wilmot Not Sold
Akbar Hussain Sold
Alex Killick Not Sold
Adam Stauber Sold


I want to find out what formular i can use, to find out the number of "Sold" for "Adam Stauber"

Thanks

Harry

[Ace_XL]

=SUMPRODUCT((A1:A7="Adam Stauber")*(b1:b7="Sold"))

You can also cell reference the fields containing the Name and Status

[Harry Basra]

Thank you very much