Your modified formula, changing "Crusher" to "A4" is doing just that. It is
comparing the values to "A4". "A4" is a text literal. If you want to
compare to the content of cell A4, simply use A4.

Tyro

"J. Trucking" wrote in message
...
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