Sum Between Values Within The Same Range

[p45cal]

See attached worksheet example

A slight tweak to C6's formula from

=SUMIFS($C$2:$C$1001,$C$2:$C$1001,">51",$C$2:$C$1001,"<100")

to

=SUMIFS($C$2:$C$1001,$C$2:$C$1001,">49",$C$2:$C$1001,"<100")