Try just typing the same formula that is in your "=SUM cell" in column a in
whatever cell in column B you wish. If that don't give you what you're
after, then please post back with specific cell information, your "=SUM"
formula and which cell in column B you wish that result to appear.

Vaya con Dios,
Chuck, CABGx3


"Xhawk57" wrote in message
...
i would like to set up an "if" formula so that it will only recognize
another
cell if it contains a formula.

example: column A has a list of numbers and then the sum of those numbers
using =sum or other similar formula. i would like to setup a formula in
column B that takes the number in the sumed cell and carries it to the
right
while leaving the remaining cells in column B blank.

could someone please help.