Actually, no. That returned a value error.

On Sat, 5 Jan 2008 20:36:15 +0800, "Max" wrote:

I used =sum(if(f20:f2000=6.5,P20:r2000)) It did the job.

but how about the earlier:
=SUMPRODUCT((F20:F2000=6.5)*(P20:R2000))

Didn't it work for you, too?
and without you having to worry about array-entering, to boot