Does anybody know how to change this fomula so that when placed in cell
it will no longer hijack the cell below.
=SUMIF($B$2:$B$100,A2,$C$2:$C$1000)

Thanks for your help!!

Jim