that is a great idea, thanks. I was being closed minded about identifying
the cell via the formula.

I made one change to streamline it and keep it from picking up unwanted cells
=if(isblank(A20),B20,"")
thanks again.
"CLR" wrote:

Do you have anything in column A just to the left of where you have a SUM in
column B?....if the cell is empty, then in column C of the same row,enter
this formula and copy it down column C as far as you have data in column
B....

Assume cell B20 is the first SUM...(if not, change the 20 as appropriate)
=IF(A20="",B20,"")

If you have some word, like "TOTAL" in column A opposite the SUM in column
B, then use this formula, changing the word TOTAL to whatever exists.....
=IF(A20="TOTAL",B20,"") ......this would go in C20 is B20 is a SUM.....

hth
Vaya con Dios,
Chuck, CABGx3





"Xhawk57" wrote in message
...
It is a very large list of names (in column A) and corresponding dollar
amounts (in column B) the names are grouped together and after each group
(
they are rouped by first letter) is a sum in column B (list all A's then
sum
of all A's, list all B's then sum of all B's,...ect) in column C I want to
pull out just the sums of each group.

Does this help clarify my problem? Please help.

"CLR" wrote:

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.