Thursday, November 20, 2014

yogi_Compute Sum Of Column E By Groups in Columns A B And C

               Google Spreadsheet   Post  #1841
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-20-2014
post by David M Cowan:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/eUV4VpHWmMI)
Formula to individually sum differently sized groups?
In something I'm working on, I need a way to combine data. The main problem I'm facing however, is that there is a much larger amount than I'm used to (I'm a student in highschool, and I have ~11000 rows of data to get through), and they're grouped into differently sized groups. I may need to sum all of group A (which if five rows tall), B (which is two rows), C (which is ten rows), and D (which is one row), and have each of them represented as one single row.
What I want to know is if there is a function which would allow me to do this, or if I can just do like some sort of fancy merge cells that adds all the values instead of only keeping the value in the top cell.

For an example, I need to sum column E (the far right one) for each individual person in the following from my sheet. However, I need the left three columns to still read "8629,2011, Frazier Todd".
86292011Frazier, Todd2013531
86292011Frazier, Todd2014597
86382011Montero, Jesus2012515
86482011Ackley, Dustin2012607
86482011Ackley, Dustin2014502
86832011Dominguez, Matt2013543
86832011Dominguez, Matt2014564
86852011Moustakas, Mike2012563
86852011Moustakas, Mike2013472
86852011Moustakas, Mike2014457
87952011Belt, Brandon2013509
88522011Chisenhall, Lonnie2014478

--------------------------------------------------------------------------------------