Sum rows based on first field

Hi,

I'm looking for a way to sum all the other columns in my spreadsheet based on the value of the first column.

So, for example, if I have this spreadsheet (I've used commas to mark the column divisions)

A0001,10,11,40
A0001,20,15,33
A0002,17,12,10
A0003,22,33,44
A0003,20,30,40

I'd like to add the rows where the first column matches and get:

A0001,30,26,73
A0002,17,12,10
A0003,42,63,84

Thanks in advance!

James
jrmcanada2Asked:
Who is Participating?
 
Shanan212Connect With a Mentor Commented:
=SUMIF($A:$A,A1,$B:$B)+SUMIF($A:$A,A1,$C:$C)+SUMIF($A:$A,A1,$D:$D)

Open in new window


The column B:B, C:C, D:D are where your values are.

Pivot table is highly recommended though!
0
 
jrmcanada2Author Commented:
The pivot table idea worked
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.