Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding cells that contain a formula
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding cells that contain a formula
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). -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jbishard" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding cells that contain a formula
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. "RagDyer" wrote: 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). -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jbishard" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding cells that contain a formula
Glad you sorted it out.
Appreciate the feedback. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jbishard" wrote in message ... 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. "RagDyer" wrote: 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). -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jbishard" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Adding cells up | Excel Worksheet Functions | |||
formula adding range of cells that contains alpha numeric | Excel Worksheet Functions | |||
adding the same formula to several cells without changing cell lin | Excel Discussion (Misc queries) | |||
Cond Formula for adding only cells of particular colour | Excel Worksheet Functions | |||
adding color to cells based on a formula | Excel Worksheet Functions |