Some cells contained a value of "", I made them zeros and it worked. Thanks
everyone.

"Don Guillett" wrote:

I didn't get an error with yours but maybe? Are your numbers numbers
=SUMPRODUCT(--($A$6:$A$488="H"),--($B$6:$B$488="B1"),C$6:C$488)*0.02

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Micki" wrote in message
...
Here's my data

Column A Column B Column C
H B1 10
I B2 12
J B2 15
K B3 14

I want to sum Column C and multiply times .02 if the values in Column A=H,
and the values in column B=B1. This formula works until I add the
multiplication factor, then I get a return of #VALUE
=SUMPRODUCT(--($A$6:$A$488="H"),--($B$6:$B$488="B1"),((C$6:C$488)*.02))