Auto sum gives answer 0 when there are cell values
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:
|