Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
I'm trying to add multiple columns in a single row. I put the formula in the
box at AB29 and used =SUM(E29:AA29) but the total figure in AB29 is way off! What should I do? -- Dragon163 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
Dragon wrote: I'm trying to add multiple columns in a single row. I put the formula in the box at AB29 and used =SUM(E29:AA29) but the total figure in AB29 is way off! What should I do? -- Dragon163 Check that what might look like numbers in the range E29:AA29 are actually numbers - they might be text values. Try these formulae: =COUNT(E29:AA29) =COUNTA(E29:AA29) Do you get the same results from each? One counts only cells containing numeric values, whereas the second one counts all the cells. If they are different then you have some cells which are text values. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
I don't see anything wrong with your formula. My guess would be that some of
your numbers are text rather than numbers. Check the formatting of your data. Also, you could try this: =SUM(VALUE(E29:AA29)) Enter this as an array formula. Ctrl-Shift-Enter instead of just Enter. If done correctly, you should see { } surrounding the formula in the Formula Bar. HTH, Elkar "Dragon" wrote: I'm trying to add multiple columns in a single row. I put the formula in the box at AB29 and used =SUM(E29:AA29) but the total figure in AB29 is way off! What should I do? -- Dragon163 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |