if you wish to stick with sumif and countif also check if the and <
should be = or <= for your logic

=sumif(a1:A100,"50")-sumif(a1:a100,"250")
=countif(a1:A100,"50")-countif(a1:a100,"250")

or use sumproduct((a1:A10050)*(a1:a100<250)) for the count

or use sumproduct((a1:A10050)*(a1:a100<250)*(a1:a100)) for the sum

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560027