+ Reply to Thread
Results 1 to 2 of 2

in excel, how do i set up a spread sheet that automatically total.

  1. #1
    jgus
    Guest

    in excel, how do i set up a spread sheet that automatically total.

    i want to set up a spread monthly numbers sheet that automatically totals how
    do i do that?


  2. #2
    JulieD
    Guest

    Re: in excel, how do i set up a spread sheet that automatically total.

    Hi

    well it depends a bit on how your data is arranged, but basically to add up
    a column of numbers you use the SUM function
    e.g.

    =SUM(A1:A31)

    where A1 is cell reference of the first number that you want to add and A31
    is the cell reference of the last cell you want included in the calculation.
    The : basically means add up everything between A1 and A31 inclusive.

    Hope this helps
    Cheers
    JulieD

    "jgus" <[email protected]> wrote in message
    news:[email protected]...
    >i want to set up a spread monthly numbers sheet that automatically totals
    >how
    > do i do that?
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1