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