I'm no expert on the use of SumProduct (and many other things as
well;),
but I think that you've just forgotten the "double minus" before each
argument (assuming that the missing parentheses are just typos).
Try
=SUMPRODUCT(--('Dec03-Dec30'!$C$2:$C$5500=$A$18)*--('Dec03-Dec30'!$I$
2:$I$5500=A21)*('Dec03-Dec30'!$I$2:$I$5500))
Rgds,
ScottO

"Curtis" wrote in message
...
| I am trying to calculate the number of instances by employee
|
| A18 = emplyee number
| column c contains range of employee numbers
| column I = contains the range of information that needs to be
counted
| a21=criteria listed within the range in column i
|
|
=SUMPRODUCT('Dec03-Dec30'!$C$2:$C$5500=$A$18)*('Dec03-Dec30'!$I$2:$I$
5500=A21)*('Dec03-Dec30'!$I$2:$I$5500)
|
| Why won't the formula above work.
|
| Please and Thanks
|
|