View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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")))