It may be that the cells not included are formatted as text rather than
numbers. Use Ctrl+F8 - or View | Value Highlighting - to display the
cell contents in different colors, depending on type. Text cells are
formatted in black, formulas in green, and number cells in blue, no
matter how their
I'm having a problem with a spreadsheet. Several rows of cells are not
being included in formulae total even though the cells are in the formulae.
They are the first five rows of a 121 row spreadsheet. when i use the auto
total button 'E' it attempts to exclude the first five rows.
Any help would
