Are you sure that you need the double unary minus when you are multiplying?
--
David Biddulph

"Pepito Delaosamayor" wrote
in message ...
=SUMPRODUCT(--(A1:A100="LifeMember")*(E1:E100="Y"))

"kshah_us" wrote:

Hello,

How can I do some thing like this:

Count an occurance if value in col. A is "LifeMember" and value in Column
E
is "Y" for a given range ? for instance A1:A100 and E1:E100 ?

I am trying COUNTIF but dont know how do I count only if BOTH conditions
are
true?


--
Thanks !