Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
spreadsheet problem
66 years old.
I have been asked to record daily my weight and blood-sugar count. I am using Excel 2003 on a Vista machine. I am trying to compare averages between doctor visits. I have both columns formatted as number (select columnformatcellsnumber, 2dp) yet when I try to sum or average the numbers, the formula only includes the last 3 cells. It also will not add the .00 to the rest of the numbers in the columns. I have selected the entire spreadsheet and made sure the protection "lock" is not selected. I hope I explain myself well enough for someone to help - I am certainly no whiz at this. Thanks in advance for all help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
spreadsheet problem
When you sum or average check your formula, i.e., =SUM(A1:A5), or
AVERAGE(A1:A5) to make sure you have the correct range of cells in the parenthesis. If the formula is correct the result should be. "Tony Vella" wrote: 66 years old. I have been asked to record daily my weight and blood-sugar count. I am using Excel 2003 on a Vista machine. I am trying to compare averages between doctor visits. I have both columns formatted as number (select columnformatcellsnumber, 2dp) yet when I try to sum or average the numbers, the formula only includes the last 3 cells. It also will not add the .00 to the rest of the numbers in the columns. I have selected the entire spreadsheet and made sure the protection "lock" is not selected. I hope I explain myself well enough for someone to help - I am certainly no whiz at this. Thanks in advance for all help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet problem | Excel Discussion (Misc queries) | |||
Problem: Xfr Spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet Formatting Problem | Excel Discussion (Misc queries) | |||
spreadsheet problem | Excel Discussion (Misc queries) | |||
Spreadsheet problem | New Users to Excel |