SUMPRODUCT issue
 

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

SUMPRODUCT issue
 

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

SUMPRODUCT issue
 

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

SUMPRODUCT issue
 

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

On Nov 5, 11:46*am, 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")))

SUMPRODUCT issue
 

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.
--
David Biddulph

"ISAF Media Analysis" wrote in
message ...
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")))