Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My SUM function is totalling to 0
i'm not an expert but i would first check the format of the cell that in
which you are creating the sum . hope this helps until an expert comes along!!! -- TomMurray "Caroline" wrote: I am calcualting sums as normal in Excel but my totals when using the SUM function are coming to 0 instead of the actual figure - 10,000. This is only ocurring in some cells and not others. I have checked the calculation tab in Options - Tools is automatic and it seems ok. PLEASE help!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My SUM function is totalling to 0
You may have numbers formatted as text, these won't sum using the sum
function. You can convert a range of text "numbers" to numeric with the following process. Put a 1 in any empty cell and copy that cell. Select your range of "numbers". Edit Paste Special under "operation" select "add" Now your SUM should work another way without touching your data. Instead of =SUM(A1:A10) use =SUMPRODUCT(--A1:A10) "tom" wrote: i'm not an expert but i would first check the format of the cell that in which you are creating the sum . hope this helps until an expert comes along!!! -- TomMurray "Caroline" wrote: I am calcualting sums as normal in Excel but my totals when using the SUM function are coming to 0 instead of the actual figure - 10,000. This is only ocurring in some cells and not others. I have checked the calculation tab in Options - Tools is automatic and it seems ok. PLEASE help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |