sum

xkboor

Board Regular
Joined
Jul 8, 2014
Messages
68
idnamevalueproduct numbersum name and value
123pen10
1
123pen52
123pen 2
317
111pencil

<tbody>
</tbody>
hello , i would like to make a sum of "value" for all "pen" that i have in my table and be in a different column
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Canapone

Active Member
Joined
May 10, 2007
Messages
463
Hi,

in column B "names", in column C "values"

=SUMIF(B$2:B$100,"pen",C$2:C$100)

Hope it helps
 
Last edited:

xkboor

Board Regular
Joined
Jul 8, 2014
Messages
68
actually becase my table is to big with 100 differrent names , I tried to do something like that : =if(b2=b3;c2+c3;.... but i want this in a loop if b2 = b3 then sum(c2+c3) , and loop if c3=c4 then sum (c3+c4) and continue
 

Canapone

Active Member
Joined
May 10, 2007
Messages
463
Hi again,

in E2 to be copied down

=IF(B2<>B3,SUMIF(B$2:B$1000,B2,C$2:C$1000),"")

Regards
 

xkboor

Board Regular
Joined
Jul 8, 2014
Messages
68
for the same "sap" i want a sum for "value" where is the date = val , and because I have more than 1000 different sap I need this in a loop !!


sapvaluedate
14005644 VAL
140056441
140056443
14005651 VAL
140056512
140056510,282
140056510,564
140056510,564
140056510,423
14005688 VAL
14005688200
14005689 VAL
14005689 VAL
14005689100
14005793 VAL
14005793 VAL
140057934000
140057931395
14005793500
14005793519
14005793490
14005793500
140057931000
14005793450
140057931000
140057931000
14005793500
14005793480
140057932000
140057931550
14005793455
140057931095
140057931000
14005793488
140057932000
14005794 VAL
14005794485
140057941000
14005794518
140057942000
140057942000
14005795 VAL
140057951000
14005795500
14005795149
14005795208
14005800 VAL
1400580015
14005802 VAL
14005802200
14005802500
14005802500
14005809 VAL
14005809500
14005829150
14005829150
14005829550
14005829150
14005829400
14005829500
14005829500
14005834 VAL
1400583430
1400583410
1400583410
14005835 VAL
1400583510
14005835115
140058358
1400583535
14005836 VAL
1400583635
1400583635
1400583610
1400583636
140058365
1400583630
1400583630
1400583621
1400583621
1400583642
1400583615
1400583620
1400583619
140058365
140058367
14005838 VAL
1400583840

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,497
Messages
5,596,508
Members
414,073
Latest member
Contilly

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top