Try
=SUMPRODUCT(--{FALSE,TRUE,TRUE,FALSE})

On SUMPROUCT
http://xldynamic.com/source/xld.SUMPRODUCT.html

On unary minus operator
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

If this post helps click Yes
---------------
Jacob Skaria


"diepvic" wrote:

Thanks Jacob & T.Valko,

It works so perfectly
Anw, could you pls explain for me how it works? What does "--" mean here?

Thanks a lot