Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"))) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"))) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Issue | Excel Worksheet Functions | |||
Sumproduct Issue | Excel Worksheet Functions | |||
I believe this is a SUMPRODUCT issue | Excel Worksheet Functions | |||
Issue with sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT issue | Excel Worksheet Functions |