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".

8629	2011	Frazier, Todd	2013	531
8629	2011	Frazier, Todd	2014	597
8638	2011	Montero, Jesus	2012	515
8648	2011	Ackley, Dustin	2012	607
8648	2011	Ackley, Dustin	2014	502
8683	2011	Dominguez, Matt	2013	543
8683	2011	Dominguez, Matt	2014	564
8685	2011	Moustakas, Mike	2012	563
8685	2011	Moustakas, Mike	2013	472
8685	2011	Moustakas, Mike	2014	457
8795	2011	Belt, Brandon	2013	509
8852	2011	Chisenhall, Lonnie	2014	478

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