I have the following formula entered into a worksheet. According to
everything I can see, it should work. There are 3 variables: Job Name, Phase
code (6.1), and whether or not the invoice is paid (X). the "I" column
contains the invoice values. It is returning a value of 0. Can anybody help
me figure this out? Thanks,
=SUMPRODUCT((F5:F179="anderson")*(H5:H179="6.1")*( O5:O179="x")*I5:I179)
--
Rich D
Armstrong Custom Homes
Redmond

Is the 6.1 really text?

What happens if you drop the "" surrounding the 6.1?

Rich D wrote:

I have the following formula entered into a worksheet. According to
everything I can see, it should work. There are 3 variables: Job Name, Phase
code (6.1), and whether or not the invoice is paid (X). the "I" column
contains the invoice values. It is returning a value of 0. Can anybody help
me figure this out? Thanks,
=SUMPRODUCT((F5:F179="anderson")*(H5:H179="6.1")*( O5:O179="x")*I5:I179)
--
Rich D
Armstrong Custom Homes
Redmond

--

Dave Peterson

Thanks!! That did it!!
--
Rich D
Armstrong Custom Homes
Redmond


"Dave Peterson" wrote:

Is the 6.1 really text?

What happens if you drop the "" surrounding the 6.1?

Rich D wrote:

I have the following formula entered into a worksheet. According to
everything I can see, it should work. There are 3 variables: Job Name, Phase
code (6.1), and whether or not the invoice is paid (X). the "I" column
contains the invoice values. It is returning a value of 0. Can anybody help
me figure this out? Thanks,
=SUMPRODUCT((F5:F179="anderson")*(H5:H179="6.1")*( O5:O179="x")*I5:I179)
--
Rich D
Armstrong Custom Homes
Redmond

--

Dave Peterson