Your numbers are not actually numbers, but text. to solve your problem,
select any empty cell in your sheet. Press <Ctrl<C. Now select B2:B17,
select Edit|Paste Special, tick Add and click OK


"brian" wrote:

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