Hi,

In both 2003 and 2007 these formulas will return errorrs if there are any
non-numeric entries in column H.

Since you haven't shown us what your data looks like or what you are trying
to do we can't propose a solution.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chad" wrote:

I cant get either of these formulas:

=SUMPRODUCT(--('Assignments Copy'!C:C="Text 1"),--('Assignments
Copy'!J:J="Text 2"),--'Assignments Copy'!H:H)

or

=SUMPRODUCT(('Assignments Copy'!C:C="Text 1")*('Assignments Copy'!J:J="Text
2")*('Assignments Copy'!H:H))

to return the proper result. In my test example, I should get 1.00, but I
get a #VALUE error. Thoughts? Any help is appreciated. Thank you.