Formula help
 

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

Formula help
 

Because ranges are not of same size!
S4:X99 should be S4:S99 or V4:X99

Regards,
Stefi

€žISAF Media Analysis€� ezt Ã*rta:

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

Formula help
 

That should work ok.

What happens when you try it?

If you get an error returned, then look for an error in one of those ranges.

If the count is not what you expected, then maybe the values in the cells aren't
what you think they are. Maybe they have extra spaces (leading, trailing or
embedded) in the strings.



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

--

Dave Peterson

Formula help
 

For V4, read X4 ? :-)
--
David Biddulph

"Stefi" wrote in message
...
Because ranges are not of same size!
S4:X99 should be S4:S99 or V4:X99

Regards,
Stefi

"ISAF Media Analysis" ezt írta:

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