Problem with formula refering to a formula. Need Help!!!

[bananapancakes42]

I have a column of values and one of the rows' values comes from a
formula. I'm trying to get the sum of these rows. But when I do the
sum function it will not add the row that has the formula in it to the
total at the bottom. it adds all other rows correctly though. On my
last years document this worked correctly now it no longer works. this
is a new layout. I found that if I put "value (sum.....)" around the
entire sum function it will calculate the correct sum and include the
formula row. I have 10,000 of these columns that need to be added so I
have no idea on how to get this "Value (......)" into each sum. If
someone could help with somethign that might be wrong with my sheet or
a way to add this in that'd be great.

The old sheets' formula will not work because everythin is completely
different.

 

[Dave Peterson]

I think I'd go back to the columns with the formulas that don't get summed
correctly.

I'd expect to find something like:

=if(a1="apple","3","5")

These "3" and "5" aren't numbers--they're text and =sum() will ignore them.

I'd fix those formulas to look more like:
=if(a1="apple",3,5)

If your formulas refer to another cell that contains text '3 not 3, then I'd fix
those original cells.

One way to fix those cells is:
select an empty cell
edit|copy
select the range of "text numbers" that need to be converted to "number numbers"
edit|paste special|check values and Add.