Say we have in A1 thru C17:
James Smith 32 $2,335
John Johnson 53 $788
Robert Williams 36 $4,020
Michael Jones 40 $730
William Brown 52 $3,500
David Davis 45 $4,995
Richard Miller 40 $1,389
Charles Wilson 57 $3,088
Joseph Moore 51 $4,663
Thomas Taylor 40 $2,482
Christopher Anderson 45 $2,454
Daniel Thomas 46 $2,691
Paul Jackson 59 $4,798
Mark White 51 $2,763
Donald Harris 39 $572
George Martin 37 $2,113
Kenneth Thompson 30 $3,268
then the formula:
=SUMPRODUCT((B1:B17>40)*(B1:B17<56)*(C1:C17))
yields $21,854
