Summing a column

Comments

3 comments

  • Official comment
    Saurabh Agashe

    Hi there,

    The best way to accomplish this, would be by creating a static column to the left of the data you'd like to add, that you'd be able to group by. You can even use text or a number to fill all columns with this value. In a separate sheet, you can then perform a GROUPBY() on the static value, then a GROUPSUM(), using the values that you'd like to get the sum of. See the attached screen shots for reference on how to accomplish this.

    Hope this helps.

    Comment actions Permalink
  • Saurabh Agashe

    Thanks for the clarification.

    How do you add these static numbers in the column. I can seem to be able to do that manually and there's no function for that I suppose?

    0
    Comment actions Permalink
  • Saurabh Agashe

    If you click on a blank column, then click into the formula bar toward the top, it will allow you to enter a value in the field. Numbers can just be entered, a string would need to be in quotes. Remember, this can't be done on a read-only sheet (like a source or join), so you may need to duplicate the sheet to perform this.

    0
    Comment actions Permalink

Please sign in to leave a comment.