SUMPRODUCT issue

[ISAF Media Analysis]

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

 

[Mike H]

try this

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

Mike

 

[Mike H]

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

 

[Pete_UK]

What does "does not work" mean? Are you getting the wrong results, a
zero, an error ??

Are you sure that column A does contain "AIP" and not "AIP " (note the
space)? The same applies for column F and for column P. The way you
have written the formula it is looking for exact matches of those
values.

Note also that you have a double bracket after the second term (only
one needed) and a triple bracket at the end (only 2 needed).

Hope this helps.

Pete

 

[joel]

You have extra parenthesis.

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

 

[David Biddulph]

The number of opening parentheses has to be equal to the number of closing
parentheses, and each pair need to match appropriately for where you are
trying to use them.