Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
I'm sure there is a very easy way to do this, but right about now my brain is
fried.\ I have a column of values that are the results of formulas. These values are scores based on the criteria set in each formula. I now need to add the scores and come up with a total score. I keep returning a "0". Any ideas? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Just how fried is your brain? Is it possible that the sum of those
values is zero? Or, it may be your formula: i sometimes intend to enter =SUM(B1:B5) and enter just the (B1:B5) part, which does not necessarily yield an error. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Are you using the SUM() function that is returning a 0?
If so, your data might be formatted as text. Try copying an empty cell, selecting the range of values you're trying to sum and "Paste Special"-Add to turn them into numbers. -- Regards, Dave "gish" wrote: I'm sure there is a very easy way to do this, but right about now my brain is fried.\ I have a column of values that are the results of formulas. These values are scores based on the criteria set in each formula. I now need to add the scores and come up with a total score. I keep returning a "0". Any ideas? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
if your scores are in A1 thru A10, then in an un-used cell enter:
=SUM(A1:A10) -- Gary's Student "gish" wrote: I'm sure there is a very easy way to do this, but right about now my brain is fried.\ I have a column of values that are the results of formulas. These values are scores based on the criteria set in each formula. I now need to add the scores and come up with a total score. I keep returning a "0". Any ideas? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Are the cells you're trying to sum formatted as Text?
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
That works, however it will not recalculate when the original values are
changed. The cells will be blank and then different people will fill in their numbers to get their scores. I need it to be able to recalculate each time the value is changed. Is there a way to do this? "David Billigmeier" wrote: Are you using the SUM() function that is returning a 0? If so, your data might be formatted as text. Try copying an empty cell, selecting the range of values you're trying to sum and "Paste Special"-Add to turn them into numbers. -- Regards, Dave "gish" wrote: I'm sure there is a very easy way to do this, but right about now my brain is fried.\ I have a column of values that are the results of formulas. These values are scores based on the criteria set in each formula. I now need to add the scores and come up with a total score. I keep returning a "0". Any ideas? Thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Tools Options; click the Calculation tab; set to Automatic.
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Not that fried. :-) The sum is 23. The sum function is correct, and the
cells are formatted as numbers. If I copy the values using paste special to an unused cell, I can sum those totals, but then the total does not recalculate if the values are changed in the original cells. "Dave O" wrote: Just how fried is your brain? Is it possible that the sum of those values is zero? Or, it may be your formula: i sometimes intend to enter =SUM(B1:B5) and enter just the (B1:B5) part, which does not necessarily yield an error. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Where you had pasted as values, try the formula =VALUE(cell reference).
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Can you give us an example of a formula from a cell in the range you're
trying to total? It shouldn't be too difficult to sum a series of numbers, after all. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Values from Formulas
Hmm, it might be still formatting the cells as text. Try to change your
SUM() function to the following: =SUM(VALUE(...)) And change the "..." to your range. Enter this with CTRL+SHIFT+ENTER, as it's an array formula. Doing it this way will always convert to numbers before calculating the sum. -- Regards, Dave "gish" wrote: That works, however it will not recalculate when the original values are changed. The cells will be blank and then different people will fill in their numbers to get their scores. I need it to be able to recalculate each time the value is changed. Is there a way to do this? "David Billigmeier" wrote: Are you using the SUM() function that is returning a 0? If so, your data might be formatted as text. Try copying an empty cell, selecting the range of values you're trying to sum and "Paste Special"-Add to turn them into numbers. -- Regards, Dave "gish" wrote: I'm sure there is a very easy way to do this, but right about now my brain is fried.\ I have a column of values that are the results of formulas. These values are scores based on the criteria set in each formula. I now need to add the scores and come up with a total score. I keep returning a "0". Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I clear a worksheet of values, but leave formulas intact? | Excel Worksheet Functions | |||
display values of formulas in Excel | Excel Worksheet Functions | |||
adding values across worksheets in a spreadsheet | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |