Summing a column

Follow

Saurabh Agashe

• April 16, 2015 18:58

Hi,

I have a column A which contains some numbers and I would like to get the sum of these numbers within that specific column A. How do I do that in Datameer?

Thanks

0

• Official comment

  

  Saurabh Agashe

  • April 16, 2015 18:59

  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

  • April 16, 2015 18:59

  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

  • April 16, 2015 19:00

  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.