Formula hijacks cell below.

J

Jim

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
 
J

Jim

THE FORMULA WOULD TAKE TWO CELLS WHEN IT WAS ONLY PLACED IN ONE. I WAS
CUTING AND PASTING THE FORMULA FROM A POST ON THIS BORD, WHEN I SHOULD
HAVE BEEN JUST TYPING IT INTO THR CELL.

THANKS,

JIM
 
D

Dave Peterson

Or just paste directly into the formula bar.
THE FORMULA WOULD TAKE TWO CELLS WHEN IT WAS ONLY PLACED IN ONE. I WAS
CUTING AND PASTING THE FORMULA FROM A POST ON THIS BORD, WHEN I SHOULD
HAVE BEEN JUST TYPING IT INTO THR CELL.

THANKS,

JIM
Click to expand...
 
Top