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