For combo count: =SUMPRODUCT(--(B4:B18=49),--(B4:B18<51))
And to sum Over and Under: =SUMIF(B4:B18,"<=49")+SUMIF(B4:B18,"51")
And to sum Within Weight:
=SUMPRODUCT(--(B4:B18=49),--(B4:B18<51),B4:B18)
I have assumed you wanted to include 49 lbs in the calculations.
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=494709