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

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

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

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

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