how do i carry a formula

X

Xhawk57

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.
 
S

SteveG

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
 
C

CLR

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
 
X

Xhawk57

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.
 
J

Jim May

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..
 
C

CLR

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
 
X

Xhawk57

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.
 
Top