View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Autosum problems

check to make sure the autosum is selecting the whole range


"Steph" wrote:

When I autosum a column I am getting an overcalculation, $65,388.28 which is
incorrect. The correct # is $63,827.50. This correct number is acheived by
adding each individual line. I received incorrect numbers all the way across
a row in each individual column. Almost as if some rows are hiding but they
aren't.

Very frustrating and I have had to go back and hand calc the reports to
verify #'s.

Thanks, Steph