Auto sum gives answer 0 when there are cell values
I am having this problem as well. I made sure that the autocalculation was
chosen in the tools. When I enter this line it will not total the numbers -
I just get $0
=SUM(J127+J125+J123+J121+J111+J109+J107+J105+J103+ J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J 16+J11+J9+J7)
"Gord Dibben" wrote:
Could be the values you see are formatted as Text
Re-format all to General
Copy an empty cell.
Select the range of values and Paste SpecialAddOKEsc.
Gord Dibben MS Excel MVP
On Thu, 14 Aug 2008 10:23:02 -0700, Coylumbridge
wrote:
|