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.