How do I mark this as answered?

From where you're posting / reading responses, ie in MS' webpages
just click the "Yes" button (like the one below) in John's response

Do note that in John's response, the parens around: $A$2:$A$100
is not necessary, ie it could be just:

=SUMPRODUCT(--($B$2:$B$100=123),--($C$2:$C$100="XD"),$A$2:$A$100)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---