Hi,

Putting your cell reference A4 in quotes make it look for the value A4 and
not the value IN A4. Try this

=SUMPRODUCT(('2007-2008 Breakdown'!$C$2:$C
$2255=A4)*(MONTH('2007-2008 Breakdown'!$A$2:$A$2255)=11)*('2007-2008
Breakdown'!$E$2:$E$2255))


"J. Trucking" wrote:

Hello,

I can't figure out why the following keeps happening. I have a list of
data with the date, type of machine, chargable hours, and non-
chargable hours. Why is it that I can do this:

=SUMPRODUCT(('2007-2008 Breakdown'!$C$2:$C
$2255="Crusher")*(MONTH('2007-2008 Breakdown'!$A$2:$A
$2255)=11)*('2007-2008 Breakdown'!$E$2:$E$2255))

With the word "Crusher" in this formula, it returns the right number.
If I write the word "Crusher" in the cell beside this one and
reference it as the cell value:

=SUMPRODUCT(('2007-2008 Breakdown'!$C$2:$C
$2255="A4")*(MONTH('2007-2008 Breakdown'!$A$2:$A$2255)=11)*('2007-2008
Breakdown'!$E$2:$E$2255))

It returns zero. Is there any way to use the cells instead of typing
each word. Thanks in advance.

John