try this

=SUMPRODUCT((A2:A200="AIP")*(F2:F200="IED")*(H2:H2 00="P"))

Mike

"ISAF Media Analysis" wrote:

Hello,

I'm trying to measure across three diferent columns, however the formula I
am using does not work. I have place the formula below. Can anyone help?
Thanks in advance.

=SUMPRODUCT(--(A2:A200="AIP"),--(F2:F200="IED")),--(H2:H200="P")))