adding cells that contain a formula

  • Thread starter Thread starter jbishard
  • Start date Start date
J

jbishard

this should be an easy one: i am trying to get the sum of numbers in a
column. SOME of the cells in that column contain a formula. i want the sum of
the cells, but it seems that when it is totalling the columns it is omiting
the cells that contain formulas. help..........thanks!
 
How about posting examples of the formulas you're using to do the summing,
AND the formulas existing in the cells you're trying to total.

Your formulas may be returning text numbers that are not recognized by the
Sum() function (if that's what you're using).
 
I just figured it out. the formula in the cells to be summed presented the
result as $150.00
Within the formula i had: "$150.00"
I removed the quotes & the $ sign.
Now I'm able to sum the cells that contain the reults of the formulas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste data from a column to a row 0
Excel formula, sum the value cell and if empty cell left blank 0
Summing rows using formulas with variables 1
Filtering with SUMIFS 1
Numbers showing Up Centered in Cell ? 1
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Formula omits adjacent cells 2
Formula help 1

Back
Top