Conditional Summing

[Rich D]

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)

 

[Dave Peterson]

Is the 6.1 really text?

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

 

[Rich D]

Thanks!! That did it!!