SUMPRODUCT issue

  • Thread starter Thread starter ISAF Media Analysis
  • Start date Start date
I

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")))
 
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
 
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
 
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.
 
Back
Top