how do i carry a formula

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in
message news:[email protected]...
>
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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.
> > >
> > >
> > >
>
>
>