General discussion

  • Creator
    Topic
  • #2307359

    excel question

    Locked

    by djcarwax ·

    what is the formula to totaling up tables automatically?

All Comments

  • Author
    Replies
    • #2745596

      Reply To: excel question

      by dklippert ·

      In reply to excel question

      Select a cell at the bottom of a column of numbers and Click on the Autosum icon on the toolbar (?)
      The formula is:
      =SUM(A1:A30)
      Or:
      Sort your data into logical groups, Months, Products, Names, etc.
      Choose one cell in the list and go to Data>Subtotals
      You can create Grand totals and subtotals whenever there is a change of name.

Viewing 0 reply threads