Formula hijacks cell below.
 

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

Formula hijacks cell below.
 

I FIGURED IT OUT,THANKS

Formula hijacks cell below.
 

Hi Jim,

What do you mean with "hijacks cell below"?

--
Kind regards,

Niek Otten

"Jim" wrote in message
oups.com...
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

Formula hijacks cell below.
 

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

Formula hijacks cell below.
 

Or just paste directly into the formula bar.

Jim wrote:

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

--

Dave Peterson