I have no idea how that works... but it does! Thanks :)

"Roger Govier" wrote:

Try
=SUMPRODUCT(--(A1:A10="A"),--(B1:B10="YES"))

--
Regards
Roger Govier