Sum formulas
 

I have a form that needs to calculate several cells that have formulas in
them. I am needing to take the results of the formula which gives me a whole
number and sum them all together in another cell. It will not sum the cells
that have formulas in them. I need for the formula to stay in the cells.
Please help. Thanks for your help

Sum formulas
 

In your formulas, remove any quotes from around any numbers.

WRONG:

=IF(A1="X","10","0")

Right:

=IF(A1="X",10,0)

Quoting numbers makes them TEXT and the SUM function ignores text.

--
Biff
Microsoft Excel MVP


"Workin girl" wrote in message
...
I have a form that needs to calculate several cells that have formulas in
them. I am needing to take the results of the formula which gives me a
whole
number and sum them all together in another cell. It will not sum the
cells
that have formulas in them. I need for the formula to stay in the cells.
Please help. Thanks for your help

Sum formulas
 

That worked great. Thanks a bunch for your help!!!!!

"T. Valko" wrote:

In your formulas, remove any quotes from around any numbers.

WRONG:

=IF(A1="X","10","0")

Right:

=IF(A1="X",10,0)

Quoting numbers makes them TEXT and the SUM function ignores text.

--
Biff
Microsoft Excel MVP


"Workin girl" wrote in message
...
I have a form that needs to calculate several cells that have formulas in
them. I am needing to take the results of the formula which gives me a
whole
number and sum them all together in another cell. It will not sum the
cells
that have formulas in them. I need for the formula to stay in the cells.
Please help. Thanks for your help

Sum formulas
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Workin girl" wrote in message
...
That worked great. Thanks a bunch for your help!!!!!

"T. Valko" wrote:

In your formulas, remove any quotes from around any numbers.

WRONG:

=IF(A1="X","10","0")

Right:

=IF(A1="X",10,0)

Quoting numbers makes them TEXT and the SUM function ignores text.

--
Biff
Microsoft Excel MVP


"Workin girl" wrote in message
...
I have a form that needs to calculate several cells that have formulas
in
them. I am needing to take the results of the formula which gives me a
whole
number and sum them all together in another cell. It will not sum the
cells
that have formulas in them. I need for the formula to stay in the
cells.
Please help. Thanks for your help