Hi,

If you are using 2003 or earlier you can't refer to the entire column with
this formula.
Change your references to J1:J65000 for example.

--
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.

Didn't work. I'm using 2007, saving the file as a 97-03.

Formula changed to: =SUMPRODUCT(--('Assignments Copy'!C2:C500="Text
1"),--('Assignments Copy'!J2:J500="Text 2"),--'Assignments Copy'!H2:H500)

"Shane Devenshire" wrote:

Hi,

If you are using 2003 or earlier you can't refer to the entire column with
this formula.
Change your references to J1:J65000 for example.

--
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.