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

I FIGURED IT OUT,THANKS

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

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

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