Sum of rows in same column if x=x
 

Good afternoon everyone:

I need to sum the values of different rows in the same column if the match a
value in the column.
10
111
20
111
30
112
40
112
42
143
15

all the information is in the same column and I need to add the rows if they
match a value, for example if 111 total 30 if 112 total 50 if 143 total 15

How can I do this?

Cheers,

Andres Angel

Sum of rows in same column if x=x
 

From your post I'm not really sure what you are trying to do. Can you
clarify your question?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=554303

Sum of rows in same column if x=x
 

What I need is to have the total number of items that hve the same header.
so if 2 or more rows have aheader 111 i need to add the values avobe each
row with the number 111.
If the value is 148 I need to add all the rows avobe the value 148.
A1 5
A2 111
A3 8
A4 148
A5 5
A6 148
A7 10
A8 111
So

111 15
148 13

I hope this helps you clarify.

Thanks


"Andres" wrote:

Good afternoon everyone:

I need to sum the values of different rows in the same column if the match a
value in the column.
10
111
20
111
30
112
40
112
42
143
15

all the information is in the same column and I need to add the rows if they
match a value, for example if 111 total 30 if 112 total 50 if 143 total 15

How can I do this?

Cheers,

Andres Angel

Sum of rows in same column if x=x
 

Here' s a formula that works for your example

C2=SUMIF(A2:A8,C1,A1:A7)

In C1 enter the number that you want to sum each row above.

For example, if C1=111 then C2=15
and if C1=148 then C2=13

This formula can easily be expanded to fit your range of data. Just
change the A2:A8 to A2:A(last row number) and change the A1:A7 to
A1:A(last row number - 1). Hope that helps.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=554303