View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ISAF Media Analysis[_2_] ISAF Media Analysis[_2_] is offline
external usenet poster
 
Posts: 21
Default 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")))