On Sat, 9 Aug 2008 18:11:33 -0300, "Bernard Liengme"
wrote:

Alternative to my SUMPRODUCT
=COUNTIF(A1:D1,1)*COUNTIF(E1:H1,5)

This formula only works under the assumption that there will never be
more than one 1 on the same row in columns A:D.
I therefore think that your first formula, with the OR, is more safe.

Lars-Åke