RE: summing
Hi Nikki
To use Autosum button from the standard toolbar, place your cursor where you want the result of the sum calculation to be displayed.
Ensure there is no data in the column immediately above the cursor position.
Ensure there is data immediately to the left of the cursor position; by then selecting Autosum Excel will confirm the summing of the row with "marching ants"
If there is data immediately above the cursor position Autosum will attempt to sum the column, you will then need to manually highlight the range of cells in the row