does

=SUMPRODUCT(--($A$6:$A$488="H"),--($B$6:$B$488="B1"),C$6:C$488))*.02

help?


On 21 Maj, 14:01, Micki wrote:
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))