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