Joined: 22 Oct 2007
|Posted: Mon Feb 02, 2009 8:02 pm Post subject: How to Create A Table of Sums sorted by Labels?
|I have some data that is of the following format (the column names are different than this, but this is just illustrative):
the letters are in one column, and the numbers are in the next column over.
What I would like to do is get Calc to calculate the sum of what each letter got.
In my example, for instance, I'd like something like:
Because if you add the numbers next to "A" through the entire data set, you get 3, etc.
Does this make sense? How do I do this in Calc?
I LOVE MYSELF