sum

[xkboor]

id	name	value	product number	sum name and value
123	pen	10	1
123	pen	5	2
123	pen	2	3	17
111	pencil

<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

 

[Canapone]

Hi,

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

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

Hope it helps

 

[ww4612]

=SUMPRODUCT(--(R2C2:R5C2="pen"),R2C3:R5C3)

 

[xkboor]

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]

Hi again,

in E2 to be copied down

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

Regards

 

[xkboor]

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 !!

sap value date 14005644 VAL 14005644 1 14005644 3 14005651 VAL 14005651 2 14005651 0,282 14005651 0,564 14005651 0,564 14005651 0,423 14005688 VAL 14005688 200 14005689 VAL 14005689 VAL 14005689 100 14005793 VAL 14005793 VAL 14005793 4000 14005793 1395 14005793 500 14005793 519 14005793 490 14005793 500 14005793 1000 14005793 450 14005793 1000 14005793 1000 14005793 500 14005793 480 14005793 2000 14005793 1550 14005793 455 14005793 1095 14005793 1000 14005793 488 14005793 2000 14005794 VAL 14005794 485 14005794 1000 14005794 518 14005794 2000 14005794 2000 14005795 VAL 14005795 1000 14005795 500 14005795 149 14005795 208 14005800 VAL 14005800 15 14005802 VAL 14005802 200 14005802 500 14005802 500 14005809 VAL 14005809 500 14005829 150 14005829 150 14005829 550 14005829 150 14005829 400 14005829 500 14005829 500 14005834 VAL 14005834 30 14005834 10 14005834 10 14005835 VAL 14005835 10 14005835 115 14005835 8 14005835 35 14005836 VAL 14005836 35 14005836 35 14005836 10 14005836 36 14005836 5 14005836 30 14005836 30 14005836 21 14005836 21 14005836 42 14005836 15 14005836 20 14005836 19 14005836 5 14005836 7 14005838 VAL 14005838 40 <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> </tbody>

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