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.

Not sure if there is more info that would no enable you to do this but
if your total is in A10, in the cell in column B that you want to carry
the sum to

=A10

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=521230

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.

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.

Paste this code into a standard module:

Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function

Then with your numbers in A1:A5
and your =sum(A1:A5) in A6
Enter into B1 and Copy Down to B6

=if(HasFormula(A1),A1,"")

That you get you what you want..





"SteveG" wrote in
message ...

Not sure if there is more info that would no enable you to do this but
if your total is in A10, in the cell in column B that you want to carry
the sum to

=A10

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=521230

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.

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.