Formula help

[ISAF Media Analysis]

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

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

 

[Sean Timmons]

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.)

 

[David Biddulph]

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.