Using the table below to test, the formula returns 0 instead of 2.

Anthony's suggestion should work. The problem lies in your data. There may
be text numbers in the numerics in cols B & C, and/or there may be extra
white spaces in the names in col A. Any of these could throw the matching
off.

This tweak should cover all possibilities:
=SUMPRODUCT(--(TRIM(A2:A200)="Melinda"),--(B2:B200+0=1),--(C2:C200+0=4),--(C2:C200+0<=8))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Melinda" wrote:
Thanks Anthony for your prompt reply. However, this formula doesn't work.
Using the table below to test, the formula returns 0 instead of 2.