Can anyone help on this. I can't figure out why this formula does not work.

=SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="neg")*(S4:X 99="SE 11.1")))

because you are looking for a sum of values in the below case. To get a
count, use --.

so:

=SUMPRODUCT(--(E4:E99="Kabul")*--(H4:H99="neg")*--(S4:X99="SE 11.1"))

will get it. (also got rid of your extra set of paretheses.)

"ISAF Media Analysis" wrote:

Can anyone help on this. I can't figure out why this formula does not work.

=SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="neg")*(S4:X 99="SE 11.1")))

What do you think the double unary minus does for you in that formula, Sean?
You've got a multiplication which coerces your booleans to numbers, so the
double unary minus doresn't do anything for you. You *would* need the
double unary minus if you had commas instead of multiplication asterisks.
--
David Biddulph

Sean Timmons wrote:
because you are looking for a sum of values in the below case. To get
a count, use --.

so:

=SUMPRODUCT(--(E4:E99="Kabul")*--(H4:H99="neg")*--(S4:X99="SE 11.1"))

will get it. (also got rid of your extra set of paretheses.)

"ISAF Media Analysis" wrote:

Can anyone help on this. I can't figure out why this formula does
not work.

=SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="neg")*(S4:X 99="SE 11.1")))