Hi,

I should have mentioned that your version of sumproduct was nearly correct,
here's yours with the syntax corrected

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

Mike

"Mike H" wrote:


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