The data was entered as numbers. My document has 7 columns each formatted

the same; however when I use the auto sum 2 columns show a 0 value. I have

tried both copying the formula and typing the formula with the same result. I

can get a calculation using multiple plus signs & entering each row/cell so

the number formatting doesn in error.

--

Jo Anna

Formatting the cells as a number isn't enough to change the value in each of the

cells.

You have a formula like =sum(a1:a10) right?

Try this formula in an empty cell: =count(a1:a10)

This will return the number of cells that are actually numbers. Then try the

technique that Gord suggested. Watch what happens to your =sum() formula and

the =count() formula.

--

Dave Peterson

cells.

You have a formula like =sum(a1:a10) right?

Try this formula in an empty cell: =count(a1:a10)

This will return the number of cells that are actually numbers. Then try the

technique that Gord suggested. Watch what happens to your =sum() formula and

the =count() formula.

--

Dave Peterson

1. =sum(A:A) add to column (B) and new value repeats w/ new sums

2. sum cells to reach a specific value and return corresponding value

3. Return Numerical Label for LAST value Subtracted to reach Sum Target Value

4. Return values that sum to a known value

5. How do I use LOOKUP to return a range of values, then SUM values?

6. VLookup multiple values - sum returned values into single cell

7. import values from access, get sum of values, return in excel?

8. Sum values depending in values next column

9. summing up values in a column based on values in 3 other colum

10. how do i sum up a column of time values but ignore negative values

11. find unique value from two coulms and sum corresponding values into third column

12. Sum up values in each column in 12 different worksheets and display value in a MsgBox

13. Sum Cell Values of one column based on Another Cell Value in a dif

14. Sum values in columns based on values in named range

15. summing values in one column that are referenced to values in anot

2 post • Page:**1** of **1**