LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
brian
 
Posts: n/a
Default excel totaling wrong

I am adding the below numbers in Column B and the last number (20) show the
total I am getting???? I checked to see what cells were being added it shows
me I B4:b17 and I then change it to B2:b17 (because it does not add these 2
cells in even if I highlight them) I don't understand why this won't work (
format cells as numbers or general
9
9
11
9
9
10
8
9
9
9
9
9
9
9
7
8
total 20

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 has wrong timing using the worksheet_change macro Jan Excel Worksheet Functions 0 January 14th 06 06:30 AM
hyperlink navigation path path wrong in Excel 2003 CE Admin Excel Discussion (Misc queries) 5 January 7th 06 07:47 PM
Excel 03 DB query pulls data in wrong order, how to resolve? reperrotte Excel Discussion (Misc queries) 1 June 8th 05 03:03 PM
In Excel spreadsheeet the dates change to the wrong date after we. ziptozipper Excel Discussion (Misc queries) 1 February 2nd 05 02:22 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"