RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
.....
je voudrais que toutes les sommes se referent dans ma table au compte 913101
s'ajoute (ici 67 000)
merci d'avance
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
.....
je voudrais que toutes les sommes se referent dans ma table au compte 913101
s'ajoute (ici 67 000)
merci d'avance
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
.....
je voudrais que toutes les sommes se referent dans ma table au compte 913101
s'ajoute (ici 67 000)
merci d'avance
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bb57a$0$9684$626a14ce@news.free.fr...
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" <ailleurs@nowhere.fr> a écrit dans le message de news:
%23cysf%23mzFHA.3152@TK2MSFTNGP10.phx.gbl...
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bb57a$0$9684$626a14ce@news.free.fr...
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" a écrit dans le message de
news:434bd700$0$8932$euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bd700$0$8932$626a14ce@news.free.fr...
euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" <ailleurs@nowhere.fr> a écrit dans le message de news:
%23cysf%23mzFHA.3152@TK2MSFTNGP10.phx.gbl...
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bb57a$0$9684$626a14ce@news.free.fr...
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" a écrit dans le message de
news:434bd700$0$8932$euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
bonjour voici ma table :
CELLULE EUR
8 8
12 32
16 34
28 52
36 49
40 14
96 5
108 5
112 14
730 169
762 36
816 9
817 15
818 13
819 31
820 52218
821 57786
822 68494,35
823 179032,66
1186 4068,7
1190 1414,27
1194 596,57
1234 6178,26
1235 5602,54
1238 2667
1239 953
1240 487
1570 68
1636 1
1639 3
1640 1
1641 1
1647 1
1650 1
1654 2
1657 7
1659 2
1673 2
1675 1
1684 1
1685 1
1686 2
1807 4
2200 4160
2584 1
2829 3
1013000000000000 -75000
1061000000000000 -7622,45
1062000000000000 -1224,51
1068000000000000 -386038,37
1200000000000000 -88370,85
1450000000000000 -458,77
1641300000000000 -208775,49
1641310000000000 -6398,74
1641320000000000 -11305,54
1641330000000000 -1874,57
1641340000000000 -1886,33
1641600000000000 -14098,56
1642000000000000 -49978,05
1642100000000000 -69030,17
1642200000000000 -83608,86
1642400000000000 -63862,28
1642600000000000 -15634,66
1642700000000000 -15888,24
1647000000000000 -76224,51
1688000000000000 -2482,62
2050000000000000 32978,9
2115000000000000 129581,66
2131000000000000 648007,13
2135000000000000 21225,02
2154000000000000 115370,92
2181000000000000 80652,84
2182000000000000 2185,19
2183000000000000 6553,88
2183100000000000 73376,84
2184000000000000 25117,3
2610000000000000 6750
2750000000000000 28059,4
2805000000000000 -14795,47
2813100000000000 -333005,28
2813500000000000 -6778,69
2815400000000000 -94059,45
2818100000000000 -53725,38
2818200000000000 -2185,19
2818300000000000 -4932,28
2818310000000000 -54805,51
2818400000000000 -19678,24
3710000000000000 34498,52
3710100000000000 136155,2
3710200000000000 57370,86
3710300000000000 275389,68
3710400000000000 352987,98
3710500000000000 97620,18
3710600000000000 90604,63
3710700000000000 20189,83
3711100000000000 11704,65
3716000000000000 62887,22
3716100000000000 36333,26
3740000000000000 204356,44
3771000000000000 125631,07
3772000000000000 241653,1
3972000000000000 -12400
3974000000000000 -26325,98
3977100000000000 -7300
3977200000000000 -24558
4011000000000000 -44096,72
4012100000000000 -948368,27
4012200000000000 -127069,94
4082000000000000 -27735,13
4083000000000000 -31180,77
4098000000000000 19310,17
4098200000000000 37507,59
4111000000000000 166897,9
4160000000000000 758,33
4183000000000000 352,4
4184000000000000 23823,1
4210000000000000 -11387,94
4251000000000000 250
4282000000000000 -38618,66
4310000000000000 -20045,52
4370000000000000 -3082,97
4373000000000000 -13272,13
4375000000000000 425,2
4382000000000000 -16303,77
4387000000000000 2135,75
4421001000000000 -835
4421002000000000 864
4440000000000000 24090,61
4456200000000000 0,38
4456600000000000 -0,47
4456610000000000 -138
4456700000000000 37457
4457050000000000 -0,24
4457060000000000 -0,12
4457130000000000 138
4457170000000000 -0,98
4458300000000000 7556,51
4458400000000000 -0,25
4458600000000000 206,05
4458700000000000 -13264,69
4486000000000000 -28501,88
4487000000000000 17805,33
4510000000000000 136183
4518000000000000 6096
4553100000000000 -36039,6
4553200000000000 -258323,54
4553400000000000 -12,2
4553500000000000 -12,2
4553600000000000 -12,2
4555000000000000 1067,14
4570000000000000 59992
4613001000000000 -1428
4710000000000000 12,5
4860000000000000 15214,85
4916000000000000 -620,55
5120000000000000 48921,92
5121000000000000 1596,63
5123000000000000 -123657
5171000000000000 2719,24
5186000000000000 -19,23
5300000000000000 782,3
5310000000000000 -443,95
6037100000000000 -6972,41
6037101000000000 -48537,65
6037102000000000 -30360,26
6037103000000000 79694,5
6037104000000000 -93638,44
6037105000000000 328398,6
6037106000000000 22187,34
6037107000000000 -20189,83
6037111000000000 19779,22
6037160000000000 -20978,1
6037161000000000 -3576,86
6037400000000000 -20717,42
6037710000000000 113126,06
6037720000000000 -5339,4
6041100000000000 118,25
6041110000000000 26986,45
6041120000000000 59614,51
6041130000000000 2019,67
6041500000000000 197
6042000000000000 11935,08
6044000000000000 3030
6045000000000000 5725,77
6061000000000000 853,53
6061100000000000 7772,23
6062000000000000 840,58
6063000000000000 408,86
6063100000000000 1063,8
6063110000000000 48,2
6064000000000000 8137,17
6064100000000000 2670,54
6064200000000000 273
6065000000000000 2693,91
6065100000000000 727,3
6067000000000000 5386,15
6067100000000000 236,94
6067200000000000 63,55
6068000000000000 7671,99
6068100000000000 439,78
6068110000000000 33,91
6068200000000000 443,95
6068400000000000 8768,96
6068410000000000 1577,53
6069000000000000 5285,51
6071000000000000 79237,14
6071010000000000 397667,39
6071020000000000 43207,11
6071030000000000 446312
6071040000000000 890322,38
6071050000000000 671217,03
6071060000000000 246608,11
6071070000000000 40629,87
6071110000000000 32820,77
6071600000000000 137080,05
6071610000000000 271459,26
6072000000000000 8849,96
6072010000000000 63390,55
6072020000000000 28804,75
6072030000000000 62530,02
6072040000000000 95147,18
6072050000000000 19309,96
6072060000000000 35997,43
6072510000000000 11704,65
6072610000000000 20832,65
6074000000000000 92034,78
6074100000000000 -818
6074300000000000 147560,1
6074400000000000 190978,51
6074500000000000 5767,95
6074600000000000 3628
6075000000000000 5828,68
6075100000000000 63898,48
6076000000000000 36175,36
6076100000000000 237,96
6076200000000000 5514,27
6076300000000000 4721,26
6076400000000000 8879,19
6077010000000000 635067,66
6077020000000000 86158,39
6077030000000000 529862,11
6077040000000000 30903,01
6077400000000000 23,71
6097100000000000 -3048,39
6097101000000000 -17544,81
6097102000000000 -1697,33
6097103000000000 -24126,2
6097104000000000 -28387,2
6097105000000000 -49315,65
6097106000000000 -23335,1
6097107000000000 -2164,21
6097111000000000 -695
6097151000000000 -3848,45
6097153000000000 -3342,22
6097160000000000 -14406,03
6097161000000000 -33957,19
6097200000000000 -88900
6097400000000000 -25335,17
6097500000000000 -636,8
6097600000000000 -3170,97
6112000000000000 303,21
6131000000000000 1636,23
6131100000000000 38,52
6132000000000000 375
6133000000000000 29946,95
6138000000000000 447,04
6152000000000000 610,46
6152100000000000 4542,47
6153000000000000 2553,89
6153100000000000 8245,67
6153200000000000 1882,84
6155000000000000 752,4
6155800000000000 58
6162000000000000 11263,08
6165000000000000 670,34
6167000000000000 262,5
6180000000000000 312,24
6182000000000000 134,62
6183000000000000 280,29
6222000000000000 1285,29
6223000000000000 460
6224000000000000 108
6226000000000000 7736
6227000000000000 245,11
6228000000000000 1529,64
6228100000000000 9,17
6230000000000000 341,64
6231000000000000 24828,41
6231100000000000 44,14
6232000000000000 6828,22
6233000000000000 270,9
6234000000000000 2796,44
6238000000000000 215
6241000000000000 1774,42
6242000000000000 4275,36
6244000000000000 356,2
6251100000000000 1367,98
6251200000000000 131,36
6251300000000000 8,36
6251400000000000 33,45
6256100000000000 588,98
6261000000000000 2708,61
6261100000000000 1653,38
6261120000000000 400
6262000000000000 6279,46
6262500000000000 304
6263000000000000 3526,29
6270000000000000 3050,41
6271100000000000 1538,86
6272000000000000 92
6278000000000000 20
6281000000000000 2899,33
6312000000000000 2043,64
6313000000000000 7311,91
6314000000000000 1781,81
6351100000000000 13026,3
6351200000000000 5039,33
6353100000000000 1930
6353110000000000 3937
6353120000000000 250
6353140000000000 338,76
6371000000000000 8389,42
6411000000000000 21320,08
6411010000000000 79693,61
6411040000000000 25171,71
6411050000000000 14253,43
6411060000000000 41800,91
6411070000000000 8022,48
6411080000000000 14748,5
6411090000000000 34935,47
6411100000000000 24201,3
6411110000000000 44351
6411120000000000 14074,5
6411130000000000 41575,18
6411140000000000 39476,34
6412000000000000 -132
6412010000000000 -4230,62
6412040000000000 3042,41
6412050000000000 -2653,96
6412060000000000 -1179,48
6412070000000000 -802,5
6412090000000000 -1014,46
6412120000000000 -651,84
6412130000000000 1695,6
6417070000000000 648
6417090000000000 648
6417100000000000 1944
6417140000000000 960
6417170000000000 -648
6417190000000000 -648
6417200000000000 -1944
6417240000000000 -960
6451000000000000 6921,45
6451010000000000 12418,99
6451040000000000 7506,61
6451050000000000 1392,34
6451060000000000 10778,68
6451070000000000 7226,9
6451090000000000 32469,75
6451120000000000 3567,04
6451130000000000 12654,26
6451140000000000 11227,29
6452000000000000 929,55
6452010000000000 3120,81
6452040000000000 1239,16
6452050000000000 509,86
6452060000000000 1781,55
6452070000000000 991,91
6452090000000000 4610,83
6452120000000000 588,28
6452130000000000 1896,78
6453000000000000 1796,87
6453010000000000 5843,93
6453040000000000 2685,18
6453050000000000 968,64
6453060000000000 3604,07
6453070000000000 1988,5
6453090000000000 11713,9
6453120000000000 1080
6453130000000000 4374,12
6453140000000000 5866,5
6453310000000000 3000,19
6454000000000000 -2,64
6454010000000000 -84,62
6454040000000000 60,85
6454050000000000 -53,08
6454060000000000 -73,59
6454070000000000 -16,05
6454090000000000 -20,29
6454120000000000 -13,03
6454130000000000 -16,09
6475000000000000 2206,05
6481000000000000 180
6481900000000000 90
6510000000000000 209,11
6530000000000000 7500
6540000000000000 400
6580000000000000 29,35
6611000000000000 16141,6
6615000000000000 -12404,47
6616100000000000 2778,18
6616200000000000 4855,01
6712000000000000 245
6720000000000000 14551
6811100000000000 5167,99
6811210000000000 30033,14
6811220000000000 9775,42
6811240000000000 5607,36
7040001091489520 -2068,01
7040001099489510 -770,91
7040003091426510 -15,05
7040003091426520 -112,3
7040003091489510 -4168,07
7040003091489520 -45465,1
7040003091489600 -2086,82
7040003099426510 -279,25
7040003099426520 -254,35
7040003099489510 -570,29
7040003099489520 -2221,08
7040003099489600 -127,93
7040004000000000 -3020,28
7040004100000000 -733,25
7045003000000000 -7569,55
7060001091489110 -2356,87
7060001099489110 -878,58
7060003091426110 -48,15
7060003091489110 -162266,72
7060003099426110 -668,1
7060003099489110 -4221,18
7063003000000000 -3970,22
7066003000000000 -22883,75
7070003091310100 -71124,61
7070003091310200 -313754,71
7070003091310300 -411961,1
7070003091310400 -735821,5
7070003091310600 -842671,65
7070003091310700 -246070,23
7070003091311600 -32441,47
7070003091311900 -38787,02
7070003091312200 -110782,11
7070003091312300 -271510,08
7070003091315500 -35017,01
7070003091315600 -592422,08
7070003091319200 -24046,82
7070003091330100 -9531,77
7070003091330200 -43257,02
7070003091330300 -86137,12
7070003091330400 -190170,55
7070003091330600 -129991,61
7070003091330700 -59277,6
7070003091331600 -13478,26
7070003091331900 -17160,45
7070003091332300 -19648,83
7074001091489010 -7303,65
7074001091489090 -148,58
7074001091489530 -787,52
7074001099489010 -0,52
7074001099489090 -3922,17
7074001099489450 -92,06
7074003091102010 -257943,27
7074003091102440 -109,04
7074003091102500 -273,6
7074003091104010 -2161,78
7074003091126010 -16157,85
7074003091126440 -24,85
7074003091126500 -86,04
7074003091189010 -53329,33
7074003091189440 -291,2
7074003091189500 -1887,59
7074003091426010 -182,23
7074003091426090 -51
7074003091489010 -227177,94
7074003091489090 -19576,21
7074003091489440 -1271,49
7074003091489500 -17925,92
7074003099102010 -8608,24
7074003099126010 -2042,5
7074003099189010 -7174,65
7074003099189450 -2051,2
7074003099426010 -207,39
7074003099426090 -270,29
7074003099426450 -51,48
7074003099489010 -765,81
7074003099489090 -4443,4
7074003099489440 -23,44
7074003099489450 -28879,34
7074003099489500 -218,6
7074003600000000 -346,04
7074103000000000 -14661,67
7074203000000000 -1627,98
7074403000000000 -98,43
7074703000000000 -57865,82
7077001091322700 -814759,62
7077001091372700 -55180,01
7077001099322700 -581148,98
7077001099372700 -60316
7077003091322700 -99518,46
7077003099322700 -5311,87
7077008000000000 -5942,57
7077020091322700 37275,67
7082008000000000 -1095,74
7082103000000000 -3068,03
7082108000000000 -6236,06
7082109000000000 -2184,2
7082203000000000 -150
7082203100000000 -238,29
7083003091489250 -870,32
7083003099489250 -41,8
7083203000000000 -300,46
7085103000000000 -4125,73
7087113000000000 3678,05
7094003091489520 78,12
7096001091489110 12,22
7096003091489110 132,01
7096003099489110 -43,78
7097003091310100 6020,08
7097003091310200 30284,64
7097003091310300 40404,46
7097003091310400 69853,96
7097003091310600 104043,69
7097003091310700 38178,92
7097003091311600 1895,48
7097003091311900 6952,01
7097003091312200 25095,53
7097003091312300 63945,55
7097003091319200 4531,25
7097003091330200 6657,39
7097003091330300 6452,34
7097003091330400 21868,73
7097003091330600 12611,21
7097003091330700 4757,53
7097401091489010 57,37
7097401091489090 26,31
7097403091102010 67733,2
7097403091102440 18,57
7097403091102500 27,36
7097403091104010 146,52
7097403091126010 9,8
7097403091189010 5292,86
7097403091189440 20,32
7097403091189500 72,68
7097403091489010 6479,66
7097403091489090 393,13
7097403091489440 16,98
7097403091489450 198,48
7097403091489500 2286,31
7097403099102010 1300,93
7097403099189010 126,24
7097403099189450 188,92
7097403099489010 1,68
7097403099489090 37,98
7097403099489450 16,23
7580000000000000 705
7720000000000000 -10490,91
7720003000000000 -373,92
7914100000000000 -3103,13
7914200000000000 -918,72
7916200000000000 -1718,19
7916300000000000 -716,25
9415500000000000 90944,75
9415500100000000 26963,79
9415500200000000 3678,84
9415500300000000 208,4
9415500500000000 8957,63
9415500600000000 4940,74
9415500700000000 567,56
9415500800000000 9812,08
9415501200000000 2975,5
9415501300000000 490,71
9417000000000000 91932,09
9704000091487510 -2642,32
9704000091487520 -26
9704000091488510 -1612,55
9704000091488520 -4921,41
9704000091488600 -150,66
9704000091788510 -2214,5
9704000091788520 -1867,05
9704000091888510 -5796,69
9704000091888520 -5247,65
9704000091888600 -70,23
9704000099488510 -3544,39
9704000099488520 -2133,55
9704000099488600 -39,47
9704000099888510 -6461,63
9704000099888520 -6713
9706000091487110 -24975,15
9706000091488110 -12618,31
9706000091788110 -17921,16
9706000091888110 -4915,02
9706000099488110 -4240,5
9706000099888110 -6923,4
9707400091487010 -63302,91
9707400091487090 -927,64
9707400091487440 -38,6
9707400091487450 -19,47
9707400091488010 -8441,95
9707400091488090 -788,26
9707400091488440 -49,32
9707400091488450 -835,39
9707400091488500 -1751,27
9707400091788010 -7959,51
9707400091788090 -1102,23
9707400091788440 -34,7
9707400091788450 -1256,79
9707400091788500 -117,78
9707400091888010 -10019,86
9707400091888090 -456,86
9707400091888440 -76,87
9707400091888450 -1089,57
9707400091888500 -2981,7
9707400099488010 -333,19
9707400099488090 -5990,01
9707400099488440 -6,39
9707400099488450 -344,31
9707400099488500 -1187,6
9707400099888010 -1228,83
9707400099888090 -11627,02
9707400099888440 -4,9
9707400099888450 -1181,1
9707400099888500 -3283,42
VA00000000000008 -34495,52
VA00000000000012 -136146,2
VA00000000000016 -275362,68
VA00000000000020 17
VA00000000000036 -97595,18
VA00000000000040 -90598,63
VA00000000000080 -1
VA00000000000092 -1
VA00000000000096 -1
VA00000000000100 -1
VA00000000000104 -1
VA00000000000108 -62888,22
VA00000000000112 -36331,26
VA00000000000337 -1
VA00000000000730 -344484,99
VA00000000000762 -1
VA00000000002584 -20189,83
VA00000000002829 -57368,86
VA00000000020463 3
XXY11655F0805
les comptes qui doivent s 'ajouter sont les compte comptable suivi
d'analytique ex :
7070003091310100 c'est le 91310100 qui est le compte analytique qui doit
servir de reference. (le tableau de bord est sur la feuille "VN" et la
table sur la "feuil1"
merci
"ru-th" a écrit dans le message de news:
%salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" a écrit dans le message de
news:434bd700$0$8932$euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
bonjour voici ma table :
CELLULE EUR
8 8
12 32
16 34
28 52
36 49
40 14
96 5
108 5
112 14
730 169
762 36
816 9
817 15
818 13
819 31
820 52218
821 57786
822 68494,35
823 179032,66
1186 4068,7
1190 1414,27
1194 596,57
1234 6178,26
1235 5602,54
1238 2667
1239 953
1240 487
1570 68
1636 1
1639 3
1640 1
1641 1
1647 1
1650 1
1654 2
1657 7
1659 2
1673 2
1675 1
1684 1
1685 1
1686 2
1807 4
2200 4160
2584 1
2829 3
1013000000000000 -75000
1061000000000000 -7622,45
1062000000000000 -1224,51
1068000000000000 -386038,37
1200000000000000 -88370,85
1450000000000000 -458,77
1641300000000000 -208775,49
1641310000000000 -6398,74
1641320000000000 -11305,54
1641330000000000 -1874,57
1641340000000000 -1886,33
1641600000000000 -14098,56
1642000000000000 -49978,05
1642100000000000 -69030,17
1642200000000000 -83608,86
1642400000000000 -63862,28
1642600000000000 -15634,66
1642700000000000 -15888,24
1647000000000000 -76224,51
1688000000000000 -2482,62
2050000000000000 32978,9
2115000000000000 129581,66
2131000000000000 648007,13
2135000000000000 21225,02
2154000000000000 115370,92
2181000000000000 80652,84
2182000000000000 2185,19
2183000000000000 6553,88
2183100000000000 73376,84
2184000000000000 25117,3
2610000000000000 6750
2750000000000000 28059,4
2805000000000000 -14795,47
2813100000000000 -333005,28
2813500000000000 -6778,69
2815400000000000 -94059,45
2818100000000000 -53725,38
2818200000000000 -2185,19
2818300000000000 -4932,28
2818310000000000 -54805,51
2818400000000000 -19678,24
3710000000000000 34498,52
3710100000000000 136155,2
3710200000000000 57370,86
3710300000000000 275389,68
3710400000000000 352987,98
3710500000000000 97620,18
3710600000000000 90604,63
3710700000000000 20189,83
3711100000000000 11704,65
3716000000000000 62887,22
3716100000000000 36333,26
3740000000000000 204356,44
3771000000000000 125631,07
3772000000000000 241653,1
3972000000000000 -12400
3974000000000000 -26325,98
3977100000000000 -7300
3977200000000000 -24558
4011000000000000 -44096,72
4012100000000000 -948368,27
4012200000000000 -127069,94
4082000000000000 -27735,13
4083000000000000 -31180,77
4098000000000000 19310,17
4098200000000000 37507,59
4111000000000000 166897,9
4160000000000000 758,33
4183000000000000 352,4
4184000000000000 23823,1
4210000000000000 -11387,94
4251000000000000 250
4282000000000000 -38618,66
4310000000000000 -20045,52
4370000000000000 -3082,97
4373000000000000 -13272,13
4375000000000000 425,2
4382000000000000 -16303,77
4387000000000000 2135,75
4421001000000000 -835
4421002000000000 864
4440000000000000 24090,61
4456200000000000 0,38
4456600000000000 -0,47
4456610000000000 -138
4456700000000000 37457
4457050000000000 -0,24
4457060000000000 -0,12
4457130000000000 138
4457170000000000 -0,98
4458300000000000 7556,51
4458400000000000 -0,25
4458600000000000 206,05
4458700000000000 -13264,69
4486000000000000 -28501,88
4487000000000000 17805,33
4510000000000000 136183
4518000000000000 6096
4553100000000000 -36039,6
4553200000000000 -258323,54
4553400000000000 -12,2
4553500000000000 -12,2
4553600000000000 -12,2
4555000000000000 1067,14
4570000000000000 59992
4613001000000000 -1428
4710000000000000 12,5
4860000000000000 15214,85
4916000000000000 -620,55
5120000000000000 48921,92
5121000000000000 1596,63
5123000000000000 -123657
5171000000000000 2719,24
5186000000000000 -19,23
5300000000000000 782,3
5310000000000000 -443,95
6037100000000000 -6972,41
6037101000000000 -48537,65
6037102000000000 -30360,26
6037103000000000 79694,5
6037104000000000 -93638,44
6037105000000000 328398,6
6037106000000000 22187,34
6037107000000000 -20189,83
6037111000000000 19779,22
6037160000000000 -20978,1
6037161000000000 -3576,86
6037400000000000 -20717,42
6037710000000000 113126,06
6037720000000000 -5339,4
6041100000000000 118,25
6041110000000000 26986,45
6041120000000000 59614,51
6041130000000000 2019,67
6041500000000000 197
6042000000000000 11935,08
6044000000000000 3030
6045000000000000 5725,77
6061000000000000 853,53
6061100000000000 7772,23
6062000000000000 840,58
6063000000000000 408,86
6063100000000000 1063,8
6063110000000000 48,2
6064000000000000 8137,17
6064100000000000 2670,54
6064200000000000 273
6065000000000000 2693,91
6065100000000000 727,3
6067000000000000 5386,15
6067100000000000 236,94
6067200000000000 63,55
6068000000000000 7671,99
6068100000000000 439,78
6068110000000000 33,91
6068200000000000 443,95
6068400000000000 8768,96
6068410000000000 1577,53
6069000000000000 5285,51
6071000000000000 79237,14
6071010000000000 397667,39
6071020000000000 43207,11
6071030000000000 446312
6071040000000000 890322,38
6071050000000000 671217,03
6071060000000000 246608,11
6071070000000000 40629,87
6071110000000000 32820,77
6071600000000000 137080,05
6071610000000000 271459,26
6072000000000000 8849,96
6072010000000000 63390,55
6072020000000000 28804,75
6072030000000000 62530,02
6072040000000000 95147,18
6072050000000000 19309,96
6072060000000000 35997,43
6072510000000000 11704,65
6072610000000000 20832,65
6074000000000000 92034,78
6074100000000000 -818
6074300000000000 147560,1
6074400000000000 190978,51
6074500000000000 5767,95
6074600000000000 3628
6075000000000000 5828,68
6075100000000000 63898,48
6076000000000000 36175,36
6076100000000000 237,96
6076200000000000 5514,27
6076300000000000 4721,26
6076400000000000 8879,19
6077010000000000 635067,66
6077020000000000 86158,39
6077030000000000 529862,11
6077040000000000 30903,01
6077400000000000 23,71
6097100000000000 -3048,39
6097101000000000 -17544,81
6097102000000000 -1697,33
6097103000000000 -24126,2
6097104000000000 -28387,2
6097105000000000 -49315,65
6097106000000000 -23335,1
6097107000000000 -2164,21
6097111000000000 -695
6097151000000000 -3848,45
6097153000000000 -3342,22
6097160000000000 -14406,03
6097161000000000 -33957,19
6097200000000000 -88900
6097400000000000 -25335,17
6097500000000000 -636,8
6097600000000000 -3170,97
6112000000000000 303,21
6131000000000000 1636,23
6131100000000000 38,52
6132000000000000 375
6133000000000000 29946,95
6138000000000000 447,04
6152000000000000 610,46
6152100000000000 4542,47
6153000000000000 2553,89
6153100000000000 8245,67
6153200000000000 1882,84
6155000000000000 752,4
6155800000000000 58
6162000000000000 11263,08
6165000000000000 670,34
6167000000000000 262,5
6180000000000000 312,24
6182000000000000 134,62
6183000000000000 280,29
6222000000000000 1285,29
6223000000000000 460
6224000000000000 108
6226000000000000 7736
6227000000000000 245,11
6228000000000000 1529,64
6228100000000000 9,17
6230000000000000 341,64
6231000000000000 24828,41
6231100000000000 44,14
6232000000000000 6828,22
6233000000000000 270,9
6234000000000000 2796,44
6238000000000000 215
6241000000000000 1774,42
6242000000000000 4275,36
6244000000000000 356,2
6251100000000000 1367,98
6251200000000000 131,36
6251300000000000 8,36
6251400000000000 33,45
6256100000000000 588,98
6261000000000000 2708,61
6261100000000000 1653,38
6261120000000000 400
6262000000000000 6279,46
6262500000000000 304
6263000000000000 3526,29
6270000000000000 3050,41
6271100000000000 1538,86
6272000000000000 92
6278000000000000 20
6281000000000000 2899,33
6312000000000000 2043,64
6313000000000000 7311,91
6314000000000000 1781,81
6351100000000000 13026,3
6351200000000000 5039,33
6353100000000000 1930
6353110000000000 3937
6353120000000000 250
6353140000000000 338,76
6371000000000000 8389,42
6411000000000000 21320,08
6411010000000000 79693,61
6411040000000000 25171,71
6411050000000000 14253,43
6411060000000000 41800,91
6411070000000000 8022,48
6411080000000000 14748,5
6411090000000000 34935,47
6411100000000000 24201,3
6411110000000000 44351
6411120000000000 14074,5
6411130000000000 41575,18
6411140000000000 39476,34
6412000000000000 -132
6412010000000000 -4230,62
6412040000000000 3042,41
6412050000000000 -2653,96
6412060000000000 -1179,48
6412070000000000 -802,5
6412090000000000 -1014,46
6412120000000000 -651,84
6412130000000000 1695,6
6417070000000000 648
6417090000000000 648
6417100000000000 1944
6417140000000000 960
6417170000000000 -648
6417190000000000 -648
6417200000000000 -1944
6417240000000000 -960
6451000000000000 6921,45
6451010000000000 12418,99
6451040000000000 7506,61
6451050000000000 1392,34
6451060000000000 10778,68
6451070000000000 7226,9
6451090000000000 32469,75
6451120000000000 3567,04
6451130000000000 12654,26
6451140000000000 11227,29
6452000000000000 929,55
6452010000000000 3120,81
6452040000000000 1239,16
6452050000000000 509,86
6452060000000000 1781,55
6452070000000000 991,91
6452090000000000 4610,83
6452120000000000 588,28
6452130000000000 1896,78
6453000000000000 1796,87
6453010000000000 5843,93
6453040000000000 2685,18
6453050000000000 968,64
6453060000000000 3604,07
6453070000000000 1988,5
6453090000000000 11713,9
6453120000000000 1080
6453130000000000 4374,12
6453140000000000 5866,5
6453310000000000 3000,19
6454000000000000 -2,64
6454010000000000 -84,62
6454040000000000 60,85
6454050000000000 -53,08
6454060000000000 -73,59
6454070000000000 -16,05
6454090000000000 -20,29
6454120000000000 -13,03
6454130000000000 -16,09
6475000000000000 2206,05
6481000000000000 180
6481900000000000 90
6510000000000000 209,11
6530000000000000 7500
6540000000000000 400
6580000000000000 29,35
6611000000000000 16141,6
6615000000000000 -12404,47
6616100000000000 2778,18
6616200000000000 4855,01
6712000000000000 245
6720000000000000 14551
6811100000000000 5167,99
6811210000000000 30033,14
6811220000000000 9775,42
6811240000000000 5607,36
7040001091489520 -2068,01
7040001099489510 -770,91
7040003091426510 -15,05
7040003091426520 -112,3
7040003091489510 -4168,07
7040003091489520 -45465,1
7040003091489600 -2086,82
7040003099426510 -279,25
7040003099426520 -254,35
7040003099489510 -570,29
7040003099489520 -2221,08
7040003099489600 -127,93
7040004000000000 -3020,28
7040004100000000 -733,25
7045003000000000 -7569,55
7060001091489110 -2356,87
7060001099489110 -878,58
7060003091426110 -48,15
7060003091489110 -162266,72
7060003099426110 -668,1
7060003099489110 -4221,18
7063003000000000 -3970,22
7066003000000000 -22883,75
7070003091310100 -71124,61
7070003091310200 -313754,71
7070003091310300 -411961,1
7070003091310400 -735821,5
7070003091310600 -842671,65
7070003091310700 -246070,23
7070003091311600 -32441,47
7070003091311900 -38787,02
7070003091312200 -110782,11
7070003091312300 -271510,08
7070003091315500 -35017,01
7070003091315600 -592422,08
7070003091319200 -24046,82
7070003091330100 -9531,77
7070003091330200 -43257,02
7070003091330300 -86137,12
7070003091330400 -190170,55
7070003091330600 -129991,61
7070003091330700 -59277,6
7070003091331600 -13478,26
7070003091331900 -17160,45
7070003091332300 -19648,83
7074001091489010 -7303,65
7074001091489090 -148,58
7074001091489530 -787,52
7074001099489010 -0,52
7074001099489090 -3922,17
7074001099489450 -92,06
7074003091102010 -257943,27
7074003091102440 -109,04
7074003091102500 -273,6
7074003091104010 -2161,78
7074003091126010 -16157,85
7074003091126440 -24,85
7074003091126500 -86,04
7074003091189010 -53329,33
7074003091189440 -291,2
7074003091189500 -1887,59
7074003091426010 -182,23
7074003091426090 -51
7074003091489010 -227177,94
7074003091489090 -19576,21
7074003091489440 -1271,49
7074003091489500 -17925,92
7074003099102010 -8608,24
7074003099126010 -2042,5
7074003099189010 -7174,65
7074003099189450 -2051,2
7074003099426010 -207,39
7074003099426090 -270,29
7074003099426450 -51,48
7074003099489010 -765,81
7074003099489090 -4443,4
7074003099489440 -23,44
7074003099489450 -28879,34
7074003099489500 -218,6
7074003600000000 -346,04
7074103000000000 -14661,67
7074203000000000 -1627,98
7074403000000000 -98,43
7074703000000000 -57865,82
7077001091322700 -814759,62
7077001091372700 -55180,01
7077001099322700 -581148,98
7077001099372700 -60316
7077003091322700 -99518,46
7077003099322700 -5311,87
7077008000000000 -5942,57
7077020091322700 37275,67
7082008000000000 -1095,74
7082103000000000 -3068,03
7082108000000000 -6236,06
7082109000000000 -2184,2
7082203000000000 -150
7082203100000000 -238,29
7083003091489250 -870,32
7083003099489250 -41,8
7083203000000000 -300,46
7085103000000000 -4125,73
7087113000000000 3678,05
7094003091489520 78,12
7096001091489110 12,22
7096003091489110 132,01
7096003099489110 -43,78
7097003091310100 6020,08
7097003091310200 30284,64
7097003091310300 40404,46
7097003091310400 69853,96
7097003091310600 104043,69
7097003091310700 38178,92
7097003091311600 1895,48
7097003091311900 6952,01
7097003091312200 25095,53
7097003091312300 63945,55
7097003091319200 4531,25
7097003091330200 6657,39
7097003091330300 6452,34
7097003091330400 21868,73
7097003091330600 12611,21
7097003091330700 4757,53
7097401091489010 57,37
7097401091489090 26,31
7097403091102010 67733,2
7097403091102440 18,57
7097403091102500 27,36
7097403091104010 146,52
7097403091126010 9,8
7097403091189010 5292,86
7097403091189440 20,32
7097403091189500 72,68
7097403091489010 6479,66
7097403091489090 393,13
7097403091489440 16,98
7097403091489450 198,48
7097403091489500 2286,31
7097403099102010 1300,93
7097403099189010 126,24
7097403099189450 188,92
7097403099489010 1,68
7097403099489090 37,98
7097403099489450 16,23
7580000000000000 705
7720000000000000 -10490,91
7720003000000000 -373,92
7914100000000000 -3103,13
7914200000000000 -918,72
7916200000000000 -1718,19
7916300000000000 -716,25
9415500000000000 90944,75
9415500100000000 26963,79
9415500200000000 3678,84
9415500300000000 208,4
9415500500000000 8957,63
9415500600000000 4940,74
9415500700000000 567,56
9415500800000000 9812,08
9415501200000000 2975,5
9415501300000000 490,71
9417000000000000 91932,09
9704000091487510 -2642,32
9704000091487520 -26
9704000091488510 -1612,55
9704000091488520 -4921,41
9704000091488600 -150,66
9704000091788510 -2214,5
9704000091788520 -1867,05
9704000091888510 -5796,69
9704000091888520 -5247,65
9704000091888600 -70,23
9704000099488510 -3544,39
9704000099488520 -2133,55
9704000099488600 -39,47
9704000099888510 -6461,63
9704000099888520 -6713
9706000091487110 -24975,15
9706000091488110 -12618,31
9706000091788110 -17921,16
9706000091888110 -4915,02
9706000099488110 -4240,5
9706000099888110 -6923,4
9707400091487010 -63302,91
9707400091487090 -927,64
9707400091487440 -38,6
9707400091487450 -19,47
9707400091488010 -8441,95
9707400091488090 -788,26
9707400091488440 -49,32
9707400091488450 -835,39
9707400091488500 -1751,27
9707400091788010 -7959,51
9707400091788090 -1102,23
9707400091788440 -34,7
9707400091788450 -1256,79
9707400091788500 -117,78
9707400091888010 -10019,86
9707400091888090 -456,86
9707400091888440 -76,87
9707400091888450 -1089,57
9707400091888500 -2981,7
9707400099488010 -333,19
9707400099488090 -5990,01
9707400099488440 -6,39
9707400099488450 -344,31
9707400099488500 -1187,6
9707400099888010 -1228,83
9707400099888090 -11627,02
9707400099888440 -4,9
9707400099888450 -1181,1
9707400099888500 -3283,42
VA00000000000008 -34495,52
VA00000000000012 -136146,2
VA00000000000016 -275362,68
VA00000000000020 17
VA00000000000036 -97595,18
VA00000000000040 -90598,63
VA00000000000080 -1
VA00000000000092 -1
VA00000000000096 -1
VA00000000000100 -1
VA00000000000104 -1
VA00000000000108 -62888,22
VA00000000000112 -36331,26
VA00000000000337 -1
VA00000000000730 -344484,99
VA00000000000762 -1
VA00000000002584 -20189,83
VA00000000002829 -57368,86
VA00000000020463 3
XXY11655F0805
les comptes qui doivent s 'ajouter sont les compte comptable suivi
d'analytique ex :
7070003091310100 c'est le 91310100 qui est le compte analytique qui doit
servir de reference. (le tableau de bord est sur la feuille "VN" et la
table sur la "feuil1"
merci
"ru-th" <ailleurs@nowhere.fr> a écrit dans le message de news:
%23sxHIenzFHA.2076@TK2MSFTNGP14.phx.gbl...
salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bd700$0$8932$626a14ce@news.free.fr...
euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" <ailleurs@nowhere.fr> a écrit dans le message de news:
%23cysf%23mzFHA.3152@TK2MSFTNGP10.phx.gbl...
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bb57a$0$9684$626a14ce@news.free.fr...
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101
s'ajoute (ici 67 000)
merci d'avance
bonjour voici ma table :
CELLULE EUR
8 8
12 32
16 34
28 52
36 49
40 14
96 5
108 5
112 14
730 169
762 36
816 9
817 15
818 13
819 31
820 52218
821 57786
822 68494,35
823 179032,66
1186 4068,7
1190 1414,27
1194 596,57
1234 6178,26
1235 5602,54
1238 2667
1239 953
1240 487
1570 68
1636 1
1639 3
1640 1
1641 1
1647 1
1650 1
1654 2
1657 7
1659 2
1673 2
1675 1
1684 1
1685 1
1686 2
1807 4
2200 4160
2584 1
2829 3
1013000000000000 -75000
1061000000000000 -7622,45
1062000000000000 -1224,51
1068000000000000 -386038,37
1200000000000000 -88370,85
1450000000000000 -458,77
1641300000000000 -208775,49
1641310000000000 -6398,74
1641320000000000 -11305,54
1641330000000000 -1874,57
1641340000000000 -1886,33
1641600000000000 -14098,56
1642000000000000 -49978,05
1642100000000000 -69030,17
1642200000000000 -83608,86
1642400000000000 -63862,28
1642600000000000 -15634,66
1642700000000000 -15888,24
1647000000000000 -76224,51
1688000000000000 -2482,62
2050000000000000 32978,9
2115000000000000 129581,66
2131000000000000 648007,13
2135000000000000 21225,02
2154000000000000 115370,92
2181000000000000 80652,84
2182000000000000 2185,19
2183000000000000 6553,88
2183100000000000 73376,84
2184000000000000 25117,3
2610000000000000 6750
2750000000000000 28059,4
2805000000000000 -14795,47
2813100000000000 -333005,28
2813500000000000 -6778,69
2815400000000000 -94059,45
2818100000000000 -53725,38
2818200000000000 -2185,19
2818300000000000 -4932,28
2818310000000000 -54805,51
2818400000000000 -19678,24
3710000000000000 34498,52
3710100000000000 136155,2
3710200000000000 57370,86
3710300000000000 275389,68
3710400000000000 352987,98
3710500000000000 97620,18
3710600000000000 90604,63
3710700000000000 20189,83
3711100000000000 11704,65
3716000000000000 62887,22
3716100000000000 36333,26
3740000000000000 204356,44
3771000000000000 125631,07
3772000000000000 241653,1
3972000000000000 -12400
3974000000000000 -26325,98
3977100000000000 -7300
3977200000000000 -24558
4011000000000000 -44096,72
4012100000000000 -948368,27
4012200000000000 -127069,94
4082000000000000 -27735,13
4083000000000000 -31180,77
4098000000000000 19310,17
4098200000000000 37507,59
4111000000000000 166897,9
4160000000000000 758,33
4183000000000000 352,4
4184000000000000 23823,1
4210000000000000 -11387,94
4251000000000000 250
4282000000000000 -38618,66
4310000000000000 -20045,52
4370000000000000 -3082,97
4373000000000000 -13272,13
4375000000000000 425,2
4382000000000000 -16303,77
4387000000000000 2135,75
4421001000000000 -835
4421002000000000 864
4440000000000000 24090,61
4456200000000000 0,38
4456600000000000 -0,47
4456610000000000 -138
4456700000000000 37457
4457050000000000 -0,24
4457060000000000 -0,12
4457130000000000 138
4457170000000000 -0,98
4458300000000000 7556,51
4458400000000000 -0,25
4458600000000000 206,05
4458700000000000 -13264,69
4486000000000000 -28501,88
4487000000000000 17805,33
4510000000000000 136183
4518000000000000 6096
4553100000000000 -36039,6
4553200000000000 -258323,54
4553400000000000 -12,2
4553500000000000 -12,2
4553600000000000 -12,2
4555000000000000 1067,14
4570000000000000 59992
4613001000000000 -1428
4710000000000000 12,5
4860000000000000 15214,85
4916000000000000 -620,55
5120000000000000 48921,92
5121000000000000 1596,63
5123000000000000 -123657
5171000000000000 2719,24
5186000000000000 -19,23
5300000000000000 782,3
5310000000000000 -443,95
6037100000000000 -6972,41
6037101000000000 -48537,65
6037102000000000 -30360,26
6037103000000000 79694,5
6037104000000000 -93638,44
6037105000000000 328398,6
6037106000000000 22187,34
6037107000000000 -20189,83
6037111000000000 19779,22
6037160000000000 -20978,1
6037161000000000 -3576,86
6037400000000000 -20717,42
6037710000000000 113126,06
6037720000000000 -5339,4
6041100000000000 118,25
6041110000000000 26986,45
6041120000000000 59614,51
6041130000000000 2019,67
6041500000000000 197
6042000000000000 11935,08
6044000000000000 3030
6045000000000000 5725,77
6061000000000000 853,53
6061100000000000 7772,23
6062000000000000 840,58
6063000000000000 408,86
6063100000000000 1063,8
6063110000000000 48,2
6064000000000000 8137,17
6064100000000000 2670,54
6064200000000000 273
6065000000000000 2693,91
6065100000000000 727,3
6067000000000000 5386,15
6067100000000000 236,94
6067200000000000 63,55
6068000000000000 7671,99
6068100000000000 439,78
6068110000000000 33,91
6068200000000000 443,95
6068400000000000 8768,96
6068410000000000 1577,53
6069000000000000 5285,51
6071000000000000 79237,14
6071010000000000 397667,39
6071020000000000 43207,11
6071030000000000 446312
6071040000000000 890322,38
6071050000000000 671217,03
6071060000000000 246608,11
6071070000000000 40629,87
6071110000000000 32820,77
6071600000000000 137080,05
6071610000000000 271459,26
6072000000000000 8849,96
6072010000000000 63390,55
6072020000000000 28804,75
6072030000000000 62530,02
6072040000000000 95147,18
6072050000000000 19309,96
6072060000000000 35997,43
6072510000000000 11704,65
6072610000000000 20832,65
6074000000000000 92034,78
6074100000000000 -818
6074300000000000 147560,1
6074400000000000 190978,51
6074500000000000 5767,95
6074600000000000 3628
6075000000000000 5828,68
6075100000000000 63898,48
6076000000000000 36175,36
6076100000000000 237,96
6076200000000000 5514,27
6076300000000000 4721,26
6076400000000000 8879,19
6077010000000000 635067,66
6077020000000000 86158,39
6077030000000000 529862,11
6077040000000000 30903,01
6077400000000000 23,71
6097100000000000 -3048,39
6097101000000000 -17544,81
6097102000000000 -1697,33
6097103000000000 -24126,2
6097104000000000 -28387,2
6097105000000000 -49315,65
6097106000000000 -23335,1
6097107000000000 -2164,21
6097111000000000 -695
6097151000000000 -3848,45
6097153000000000 -3342,22
6097160000000000 -14406,03
6097161000000000 -33957,19
6097200000000000 -88900
6097400000000000 -25335,17
6097500000000000 -636,8
6097600000000000 -3170,97
6112000000000000 303,21
6131000000000000 1636,23
6131100000000000 38,52
6132000000000000 375
6133000000000000 29946,95
6138000000000000 447,04
6152000000000000 610,46
6152100000000000 4542,47
6153000000000000 2553,89
6153100000000000 8245,67
6153200000000000 1882,84
6155000000000000 752,4
6155800000000000 58
6162000000000000 11263,08
6165000000000000 670,34
6167000000000000 262,5
6180000000000000 312,24
6182000000000000 134,62
6183000000000000 280,29
6222000000000000 1285,29
6223000000000000 460
6224000000000000 108
6226000000000000 7736
6227000000000000 245,11
6228000000000000 1529,64
6228100000000000 9,17
6230000000000000 341,64
6231000000000000 24828,41
6231100000000000 44,14
6232000000000000 6828,22
6233000000000000 270,9
6234000000000000 2796,44
6238000000000000 215
6241000000000000 1774,42
6242000000000000 4275,36
6244000000000000 356,2
6251100000000000 1367,98
6251200000000000 131,36
6251300000000000 8,36
6251400000000000 33,45
6256100000000000 588,98
6261000000000000 2708,61
6261100000000000 1653,38
6261120000000000 400
6262000000000000 6279,46
6262500000000000 304
6263000000000000 3526,29
6270000000000000 3050,41
6271100000000000 1538,86
6272000000000000 92
6278000000000000 20
6281000000000000 2899,33
6312000000000000 2043,64
6313000000000000 7311,91
6314000000000000 1781,81
6351100000000000 13026,3
6351200000000000 5039,33
6353100000000000 1930
6353110000000000 3937
6353120000000000 250
6353140000000000 338,76
6371000000000000 8389,42
6411000000000000 21320,08
6411010000000000 79693,61
6411040000000000 25171,71
6411050000000000 14253,43
6411060000000000 41800,91
6411070000000000 8022,48
6411080000000000 14748,5
6411090000000000 34935,47
6411100000000000 24201,3
6411110000000000 44351
6411120000000000 14074,5
6411130000000000 41575,18
6411140000000000 39476,34
6412000000000000 -132
6412010000000000 -4230,62
6412040000000000 3042,41
6412050000000000 -2653,96
6412060000000000 -1179,48
6412070000000000 -802,5
6412090000000000 -1014,46
6412120000000000 -651,84
6412130000000000 1695,6
6417070000000000 648
6417090000000000 648
6417100000000000 1944
6417140000000000 960
6417170000000000 -648
6417190000000000 -648
6417200000000000 -1944
6417240000000000 -960
6451000000000000 6921,45
6451010000000000 12418,99
6451040000000000 7506,61
6451050000000000 1392,34
6451060000000000 10778,68
6451070000000000 7226,9
6451090000000000 32469,75
6451120000000000 3567,04
6451130000000000 12654,26
6451140000000000 11227,29
6452000000000000 929,55
6452010000000000 3120,81
6452040000000000 1239,16
6452050000000000 509,86
6452060000000000 1781,55
6452070000000000 991,91
6452090000000000 4610,83
6452120000000000 588,28
6452130000000000 1896,78
6453000000000000 1796,87
6453010000000000 5843,93
6453040000000000 2685,18
6453050000000000 968,64
6453060000000000 3604,07
6453070000000000 1988,5
6453090000000000 11713,9
6453120000000000 1080
6453130000000000 4374,12
6453140000000000 5866,5
6453310000000000 3000,19
6454000000000000 -2,64
6454010000000000 -84,62
6454040000000000 60,85
6454050000000000 -53,08
6454060000000000 -73,59
6454070000000000 -16,05
6454090000000000 -20,29
6454120000000000 -13,03
6454130000000000 -16,09
6475000000000000 2206,05
6481000000000000 180
6481900000000000 90
6510000000000000 209,11
6530000000000000 7500
6540000000000000 400
6580000000000000 29,35
6611000000000000 16141,6
6615000000000000 -12404,47
6616100000000000 2778,18
6616200000000000 4855,01
6712000000000000 245
6720000000000000 14551
6811100000000000 5167,99
6811210000000000 30033,14
6811220000000000 9775,42
6811240000000000 5607,36
7040001091489520 -2068,01
7040001099489510 -770,91
7040003091426510 -15,05
7040003091426520 -112,3
7040003091489510 -4168,07
7040003091489520 -45465,1
7040003091489600 -2086,82
7040003099426510 -279,25
7040003099426520 -254,35
7040003099489510 -570,29
7040003099489520 -2221,08
7040003099489600 -127,93
7040004000000000 -3020,28
7040004100000000 -733,25
7045003000000000 -7569,55
7060001091489110 -2356,87
7060001099489110 -878,58
7060003091426110 -48,15
7060003091489110 -162266,72
7060003099426110 -668,1
7060003099489110 -4221,18
7063003000000000 -3970,22
7066003000000000 -22883,75
7070003091310100 -71124,61
7070003091310200 -313754,71
7070003091310300 -411961,1
7070003091310400 -735821,5
7070003091310600 -842671,65
7070003091310700 -246070,23
7070003091311600 -32441,47
7070003091311900 -38787,02
7070003091312200 -110782,11
7070003091312300 -271510,08
7070003091315500 -35017,01
7070003091315600 -592422,08
7070003091319200 -24046,82
7070003091330100 -9531,77
7070003091330200 -43257,02
7070003091330300 -86137,12
7070003091330400 -190170,55
7070003091330600 -129991,61
7070003091330700 -59277,6
7070003091331600 -13478,26
7070003091331900 -17160,45
7070003091332300 -19648,83
7074001091489010 -7303,65
7074001091489090 -148,58
7074001091489530 -787,52
7074001099489010 -0,52
7074001099489090 -3922,17
7074001099489450 -92,06
7074003091102010 -257943,27
7074003091102440 -109,04
7074003091102500 -273,6
7074003091104010 -2161,78
7074003091126010 -16157,85
7074003091126440 -24,85
7074003091126500 -86,04
7074003091189010 -53329,33
7074003091189440 -291,2
7074003091189500 -1887,59
7074003091426010 -182,23
7074003091426090 -51
7074003091489010 -227177,94
7074003091489090 -19576,21
7074003091489440 -1271,49
7074003091489500 -17925,92
7074003099102010 -8608,24
7074003099126010 -2042,5
7074003099189010 -7174,65
7074003099189450 -2051,2
7074003099426010 -207,39
7074003099426090 -270,29
7074003099426450 -51,48
7074003099489010 -765,81
7074003099489090 -4443,4
7074003099489440 -23,44
7074003099489450 -28879,34
7074003099489500 -218,6
7074003600000000 -346,04
7074103000000000 -14661,67
7074203000000000 -1627,98
7074403000000000 -98,43
7074703000000000 -57865,82
7077001091322700 -814759,62
7077001091372700 -55180,01
7077001099322700 -581148,98
7077001099372700 -60316
7077003091322700 -99518,46
7077003099322700 -5311,87
7077008000000000 -5942,57
7077020091322700 37275,67
7082008000000000 -1095,74
7082103000000000 -3068,03
7082108000000000 -6236,06
7082109000000000 -2184,2
7082203000000000 -150
7082203100000000 -238,29
7083003091489250 -870,32
7083003099489250 -41,8
7083203000000000 -300,46
7085103000000000 -4125,73
7087113000000000 3678,05
7094003091489520 78,12
7096001091489110 12,22
7096003091489110 132,01
7096003099489110 -43,78
7097003091310100 6020,08
7097003091310200 30284,64
7097003091310300 40404,46
7097003091310400 69853,96
7097003091310600 104043,69
7097003091310700 38178,92
7097003091311600 1895,48
7097003091311900 6952,01
7097003091312200 25095,53
7097003091312300 63945,55
7097003091319200 4531,25
7097003091330200 6657,39
7097003091330300 6452,34
7097003091330400 21868,73
7097003091330600 12611,21
7097003091330700 4757,53
7097401091489010 57,37
7097401091489090 26,31
7097403091102010 67733,2
7097403091102440 18,57
7097403091102500 27,36
7097403091104010 146,52
7097403091126010 9,8
7097403091189010 5292,86
7097403091189440 20,32
7097403091189500 72,68
7097403091489010 6479,66
7097403091489090 393,13
7097403091489440 16,98
7097403091489450 198,48
7097403091489500 2286,31
7097403099102010 1300,93
7097403099189010 126,24
7097403099189450 188,92
7097403099489010 1,68
7097403099489090 37,98
7097403099489450 16,23
7580000000000000 705
7720000000000000 -10490,91
7720003000000000 -373,92
7914100000000000 -3103,13
7914200000000000 -918,72
7916200000000000 -1718,19
7916300000000000 -716,25
9415500000000000 90944,75
9415500100000000 26963,79
9415500200000000 3678,84
9415500300000000 208,4
9415500500000000 8957,63
9415500600000000 4940,74
9415500700000000 567,56
9415500800000000 9812,08
9415501200000000 2975,5
9415501300000000 490,71
9417000000000000 91932,09
9704000091487510 -2642,32
9704000091487520 -26
9704000091488510 -1612,55
9704000091488520 -4921,41
9704000091488600 -150,66
9704000091788510 -2214,5
9704000091788520 -1867,05
9704000091888510 -5796,69
9704000091888520 -5247,65
9704000091888600 -70,23
9704000099488510 -3544,39
9704000099488520 -2133,55
9704000099488600 -39,47
9704000099888510 -6461,63
9704000099888520 -6713
9706000091487110 -24975,15
9706000091488110 -12618,31
9706000091788110 -17921,16
9706000091888110 -4915,02
9706000099488110 -4240,5
9706000099888110 -6923,4
9707400091487010 -63302,91
9707400091487090 -927,64
9707400091487440 -38,6
9707400091487450 -19,47
9707400091488010 -8441,95
9707400091488090 -788,26
9707400091488440 -49,32
9707400091488450 -835,39
9707400091488500 -1751,27
9707400091788010 -7959,51
9707400091788090 -1102,23
9707400091788440 -34,7
9707400091788450 -1256,79
9707400091788500 -117,78
9707400091888010 -10019,86
9707400091888090 -456,86
9707400091888440 -76,87
9707400091888450 -1089,57
9707400091888500 -2981,7
9707400099488010 -333,19
9707400099488090 -5990,01
9707400099488440 -6,39
9707400099488450 -344,31
9707400099488500 -1187,6
9707400099888010 -1228,83
9707400099888090 -11627,02
9707400099888440 -4,9
9707400099888450 -1181,1
9707400099888500 -3283,42
VA00000000000008 -34495,52
VA00000000000012 -136146,2
VA00000000000016 -275362,68
VA00000000000020 17
VA00000000000036 -97595,18
VA00000000000040 -90598,63
VA00000000000080 -1
VA00000000000092 -1
VA00000000000096 -1
VA00000000000100 -1
VA00000000000104 -1
VA00000000000108 -62888,22
VA00000000000112 -36331,26
VA00000000000337 -1
VA00000000000730 -344484,99
VA00000000000762 -1
VA00000000002584 -20189,83
VA00000000002829 -57368,86
VA00000000020463 3
XXY11655F0805
les comptes qui doivent s 'ajouter sont les compte comptable suivi
d'analytique ex :
7070003091310100 c'est le 91310100 qui est le compte analytique qui doit
servir de reference. (le tableau de bord est sur la feuille "VN" et la
table sur la "feuil1"
merci
"ru-th" a écrit dans le message de news:
%salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" a écrit dans le message de
news:434bd700$0$8932$euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au compte
913101s'ajoute (ici 67 000)
merci d'avance
Bonjour
=SOMMEPROD((DROITE(A2:A641;8)="91310100")*(B2:B641))
donne -65104,53 est-ce le résultat que tu souhaites ?
Stéphane
"lolo" a écrit dans le message de news:
434cb320$0$7364$bonjour voici ma table :
CELLULE EUR
8 8
12 32
16 34
28 52
36 49
40 14
96 5
108 5
112 14
730 169
762 36
816 9
817 15
818 13
819 31
820 52218
821 57786
822 68494,35
823 179032,66
1186 4068,7
1190 1414,27
1194 596,57
1234 6178,26
1235 5602,54
1238 2667
1239 953
1240 487
1570 68
1636 1
1639 3
1640 1
1641 1
1647 1
1650 1
1654 2
1657 7
1659 2
1673 2
1675 1
1684 1
1685 1
1686 2
1807 4
2200 4160
2584 1
2829 3
1013000000000000 -75000
1061000000000000 -7622,45
1062000000000000 -1224,51
1068000000000000 -386038,37
1200000000000000 -88370,85
1450000000000000 -458,77
1641300000000000 -208775,49
1641310000000000 -6398,74
1641320000000000 -11305,54
1641330000000000 -1874,57
1641340000000000 -1886,33
1641600000000000 -14098,56
1642000000000000 -49978,05
1642100000000000 -69030,17
1642200000000000 -83608,86
1642400000000000 -63862,28
1642600000000000 -15634,66
1642700000000000 -15888,24
1647000000000000 -76224,51
1688000000000000 -2482,62
2050000000000000 32978,9
2115000000000000 129581,66
2131000000000000 648007,13
2135000000000000 21225,02
2154000000000000 115370,92
2181000000000000 80652,84
2182000000000000 2185,19
2183000000000000 6553,88
2183100000000000 73376,84
2184000000000000 25117,3
2610000000000000 6750
2750000000000000 28059,4
2805000000000000 -14795,47
2813100000000000 -333005,28
2813500000000000 -6778,69
2815400000000000 -94059,45
2818100000000000 -53725,38
2818200000000000 -2185,19
2818300000000000 -4932,28
2818310000000000 -54805,51
2818400000000000 -19678,24
3710000000000000 34498,52
3710100000000000 136155,2
3710200000000000 57370,86
3710300000000000 275389,68
3710400000000000 352987,98
3710500000000000 97620,18
3710600000000000 90604,63
3710700000000000 20189,83
3711100000000000 11704,65
3716000000000000 62887,22
3716100000000000 36333,26
3740000000000000 204356,44
3771000000000000 125631,07
3772000000000000 241653,1
3972000000000000 -12400
3974000000000000 -26325,98
3977100000000000 -7300
3977200000000000 -24558
4011000000000000 -44096,72
4012100000000000 -948368,27
4012200000000000 -127069,94
4082000000000000 -27735,13
4083000000000000 -31180,77
4098000000000000 19310,17
4098200000000000 37507,59
4111000000000000 166897,9
4160000000000000 758,33
4183000000000000 352,4
4184000000000000 23823,1
4210000000000000 -11387,94
4251000000000000 250
4282000000000000 -38618,66
4310000000000000 -20045,52
4370000000000000 -3082,97
4373000000000000 -13272,13
4375000000000000 425,2
4382000000000000 -16303,77
4387000000000000 2135,75
4421001000000000 -835
4421002000000000 864
4440000000000000 24090,61
4456200000000000 0,38
4456600000000000 -0,47
4456610000000000 -138
4456700000000000 37457
4457050000000000 -0,24
4457060000000000 -0,12
4457130000000000 138
4457170000000000 -0,98
4458300000000000 7556,51
4458400000000000 -0,25
4458600000000000 206,05
4458700000000000 -13264,69
4486000000000000 -28501,88
4487000000000000 17805,33
4510000000000000 136183
4518000000000000 6096
4553100000000000 -36039,6
4553200000000000 -258323,54
4553400000000000 -12,2
4553500000000000 -12,2
4553600000000000 -12,2
4555000000000000 1067,14
4570000000000000 59992
4613001000000000 -1428
4710000000000000 12,5
4860000000000000 15214,85
4916000000000000 -620,55
5120000000000000 48921,92
5121000000000000 1596,63
5123000000000000 -123657
5171000000000000 2719,24
5186000000000000 -19,23
5300000000000000 782,3
5310000000000000 -443,95
6037100000000000 -6972,41
6037101000000000 -48537,65
6037102000000000 -30360,26
6037103000000000 79694,5
6037104000000000 -93638,44
6037105000000000 328398,6
6037106000000000 22187,34
6037107000000000 -20189,83
6037111000000000 19779,22
6037160000000000 -20978,1
6037161000000000 -3576,86
6037400000000000 -20717,42
6037710000000000 113126,06
6037720000000000 -5339,4
6041100000000000 118,25
6041110000000000 26986,45
6041120000000000 59614,51
6041130000000000 2019,67
6041500000000000 197
6042000000000000 11935,08
6044000000000000 3030
6045000000000000 5725,77
6061000000000000 853,53
6061100000000000 7772,23
6062000000000000 840,58
6063000000000000 408,86
6063100000000000 1063,8
6063110000000000 48,2
6064000000000000 8137,17
6064100000000000 2670,54
6064200000000000 273
6065000000000000 2693,91
6065100000000000 727,3
6067000000000000 5386,15
6067100000000000 236,94
6067200000000000 63,55
6068000000000000 7671,99
6068100000000000 439,78
6068110000000000 33,91
6068200000000000 443,95
6068400000000000 8768,96
6068410000000000 1577,53
6069000000000000 5285,51
6071000000000000 79237,14
6071010000000000 397667,39
6071020000000000 43207,11
6071030000000000 446312
6071040000000000 890322,38
6071050000000000 671217,03
6071060000000000 246608,11
6071070000000000 40629,87
6071110000000000 32820,77
6071600000000000 137080,05
6071610000000000 271459,26
6072000000000000 8849,96
6072010000000000 63390,55
6072020000000000 28804,75
6072030000000000 62530,02
6072040000000000 95147,18
6072050000000000 19309,96
6072060000000000 35997,43
6072510000000000 11704,65
6072610000000000 20832,65
6074000000000000 92034,78
6074100000000000 -818
6074300000000000 147560,1
6074400000000000 190978,51
6074500000000000 5767,95
6074600000000000 3628
6075000000000000 5828,68
6075100000000000 63898,48
6076000000000000 36175,36
6076100000000000 237,96
6076200000000000 5514,27
6076300000000000 4721,26
6076400000000000 8879,19
6077010000000000 635067,66
6077020000000000 86158,39
6077030000000000 529862,11
6077040000000000 30903,01
6077400000000000 23,71
6097100000000000 -3048,39
6097101000000000 -17544,81
6097102000000000 -1697,33
6097103000000000 -24126,2
6097104000000000 -28387,2
6097105000000000 -49315,65
6097106000000000 -23335,1
6097107000000000 -2164,21
6097111000000000 -695
6097151000000000 -3848,45
6097153000000000 -3342,22
6097160000000000 -14406,03
6097161000000000 -33957,19
6097200000000000 -88900
6097400000000000 -25335,17
6097500000000000 -636,8
6097600000000000 -3170,97
6112000000000000 303,21
6131000000000000 1636,23
6131100000000000 38,52
6132000000000000 375
6133000000000000 29946,95
6138000000000000 447,04
6152000000000000 610,46
6152100000000000 4542,47
6153000000000000 2553,89
6153100000000000 8245,67
6153200000000000 1882,84
6155000000000000 752,4
6155800000000000 58
6162000000000000 11263,08
6165000000000000 670,34
6167000000000000 262,5
6180000000000000 312,24
6182000000000000 134,62
6183000000000000 280,29
6222000000000000 1285,29
6223000000000000 460
6224000000000000 108
6226000000000000 7736
6227000000000000 245,11
6228000000000000 1529,64
6228100000000000 9,17
6230000000000000 341,64
6231000000000000 24828,41
6231100000000000 44,14
6232000000000000 6828,22
6233000000000000 270,9
6234000000000000 2796,44
6238000000000000 215
6241000000000000 1774,42
6242000000000000 4275,36
6244000000000000 356,2
6251100000000000 1367,98
6251200000000000 131,36
6251300000000000 8,36
6251400000000000 33,45
6256100000000000 588,98
6261000000000000 2708,61
6261100000000000 1653,38
6261120000000000 400
6262000000000000 6279,46
6262500000000000 304
6263000000000000 3526,29
6270000000000000 3050,41
6271100000000000 1538,86
6272000000000000 92
6278000000000000 20
6281000000000000 2899,33
6312000000000000 2043,64
6313000000000000 7311,91
6314000000000000 1781,81
6351100000000000 13026,3
6351200000000000 5039,33
6353100000000000 1930
6353110000000000 3937
6353120000000000 250
6353140000000000 338,76
6371000000000000 8389,42
6411000000000000 21320,08
6411010000000000 79693,61
6411040000000000 25171,71
6411050000000000 14253,43
6411060000000000 41800,91
6411070000000000 8022,48
6411080000000000 14748,5
6411090000000000 34935,47
6411100000000000 24201,3
6411110000000000 44351
6411120000000000 14074,5
6411130000000000 41575,18
6411140000000000 39476,34
6412000000000000 -132
6412010000000000 -4230,62
6412040000000000 3042,41
6412050000000000 -2653,96
6412060000000000 -1179,48
6412070000000000 -802,5
6412090000000000 -1014,46
6412120000000000 -651,84
6412130000000000 1695,6
6417070000000000 648
6417090000000000 648
6417100000000000 1944
6417140000000000 960
6417170000000000 -648
6417190000000000 -648
6417200000000000 -1944
6417240000000000 -960
6451000000000000 6921,45
6451010000000000 12418,99
6451040000000000 7506,61
6451050000000000 1392,34
6451060000000000 10778,68
6451070000000000 7226,9
6451090000000000 32469,75
6451120000000000 3567,04
6451130000000000 12654,26
6451140000000000 11227,29
6452000000000000 929,55
6452010000000000 3120,81
6452040000000000 1239,16
6452050000000000 509,86
6452060000000000 1781,55
6452070000000000 991,91
6452090000000000 4610,83
6452120000000000 588,28
6452130000000000 1896,78
6453000000000000 1796,87
6453010000000000 5843,93
6453040000000000 2685,18
6453050000000000 968,64
6453060000000000 3604,07
6453070000000000 1988,5
6453090000000000 11713,9
6453120000000000 1080
6453130000000000 4374,12
6453140000000000 5866,5
6453310000000000 3000,19
6454000000000000 -2,64
6454010000000000 -84,62
6454040000000000 60,85
6454050000000000 -53,08
6454060000000000 -73,59
6454070000000000 -16,05
6454090000000000 -20,29
6454120000000000 -13,03
6454130000000000 -16,09
6475000000000000 2206,05
6481000000000000 180
6481900000000000 90
6510000000000000 209,11
6530000000000000 7500
6540000000000000 400
6580000000000000 29,35
6611000000000000 16141,6
6615000000000000 -12404,47
6616100000000000 2778,18
6616200000000000 4855,01
6712000000000000 245
6720000000000000 14551
6811100000000000 5167,99
6811210000000000 30033,14
6811220000000000 9775,42
6811240000000000 5607,36
7040001091489520 -2068,01
7040001099489510 -770,91
7040003091426510 -15,05
7040003091426520 -112,3
7040003091489510 -4168,07
7040003091489520 -45465,1
7040003091489600 -2086,82
7040003099426510 -279,25
7040003099426520 -254,35
7040003099489510 -570,29
7040003099489520 -2221,08
7040003099489600 -127,93
7040004000000000 -3020,28
7040004100000000 -733,25
7045003000000000 -7569,55
7060001091489110 -2356,87
7060001099489110 -878,58
7060003091426110 -48,15
7060003091489110 -162266,72
7060003099426110 -668,1
7060003099489110 -4221,18
7063003000000000 -3970,22
7066003000000000 -22883,75
7070003091310100 -71124,61
7070003091310200 -313754,71
7070003091310300 -411961,1
7070003091310400 -735821,5
7070003091310600 -842671,65
7070003091310700 -246070,23
7070003091311600 -32441,47
7070003091311900 -38787,02
7070003091312200 -110782,11
7070003091312300 -271510,08
7070003091315500 -35017,01
7070003091315600 -592422,08
7070003091319200 -24046,82
7070003091330100 -9531,77
7070003091330200 -43257,02
7070003091330300 -86137,12
7070003091330400 -190170,55
7070003091330600 -129991,61
7070003091330700 -59277,6
7070003091331600 -13478,26
7070003091331900 -17160,45
7070003091332300 -19648,83
7074001091489010 -7303,65
7074001091489090 -148,58
7074001091489530 -787,52
7074001099489010 -0,52
7074001099489090 -3922,17
7074001099489450 -92,06
7074003091102010 -257943,27
7074003091102440 -109,04
7074003091102500 -273,6
7074003091104010 -2161,78
7074003091126010 -16157,85
7074003091126440 -24,85
7074003091126500 -86,04
7074003091189010 -53329,33
7074003091189440 -291,2
7074003091189500 -1887,59
7074003091426010 -182,23
7074003091426090 -51
7074003091489010 -227177,94
7074003091489090 -19576,21
7074003091489440 -1271,49
7074003091489500 -17925,92
7074003099102010 -8608,24
7074003099126010 -2042,5
7074003099189010 -7174,65
7074003099189450 -2051,2
7074003099426010 -207,39
7074003099426090 -270,29
7074003099426450 -51,48
7074003099489010 -765,81
7074003099489090 -4443,4
7074003099489440 -23,44
7074003099489450 -28879,34
7074003099489500 -218,6
7074003600000000 -346,04
7074103000000000 -14661,67
7074203000000000 -1627,98
7074403000000000 -98,43
7074703000000000 -57865,82
7077001091322700 -814759,62
7077001091372700 -55180,01
7077001099322700 -581148,98
7077001099372700 -60316
7077003091322700 -99518,46
7077003099322700 -5311,87
7077008000000000 -5942,57
7077020091322700 37275,67
7082008000000000 -1095,74
7082103000000000 -3068,03
7082108000000000 -6236,06
7082109000000000 -2184,2
7082203000000000 -150
7082203100000000 -238,29
7083003091489250 -870,32
7083003099489250 -41,8
7083203000000000 -300,46
7085103000000000 -4125,73
7087113000000000 3678,05
7094003091489520 78,12
7096001091489110 12,22
7096003091489110 132,01
7096003099489110 -43,78
7097003091310100 6020,08
7097003091310200 30284,64
7097003091310300 40404,46
7097003091310400 69853,96
7097003091310600 104043,69
7097003091310700 38178,92
7097003091311600 1895,48
7097003091311900 6952,01
7097003091312200 25095,53
7097003091312300 63945,55
7097003091319200 4531,25
7097003091330200 6657,39
7097003091330300 6452,34
7097003091330400 21868,73
7097003091330600 12611,21
7097003091330700 4757,53
7097401091489010 57,37
7097401091489090 26,31
7097403091102010 67733,2
7097403091102440 18,57
7097403091102500 27,36
7097403091104010 146,52
7097403091126010 9,8
7097403091189010 5292,86
7097403091189440 20,32
7097403091189500 72,68
7097403091489010 6479,66
7097403091489090 393,13
7097403091489440 16,98
7097403091489450 198,48
7097403091489500 2286,31
7097403099102010 1300,93
7097403099189010 126,24
7097403099189450 188,92
7097403099489010 1,68
7097403099489090 37,98
7097403099489450 16,23
7580000000000000 705
7720000000000000 -10490,91
7720003000000000 -373,92
7914100000000000 -3103,13
7914200000000000 -918,72
7916200000000000 -1718,19
7916300000000000 -716,25
9415500000000000 90944,75
9415500100000000 26963,79
9415500200000000 3678,84
9415500300000000 208,4
9415500500000000 8957,63
9415500600000000 4940,74
9415500700000000 567,56
9415500800000000 9812,08
9415501200000000 2975,5
9415501300000000 490,71
9417000000000000 91932,09
9704000091487510 -2642,32
9704000091487520 -26
9704000091488510 -1612,55
9704000091488520 -4921,41
9704000091488600 -150,66
9704000091788510 -2214,5
9704000091788520 -1867,05
9704000091888510 -5796,69
9704000091888520 -5247,65
9704000091888600 -70,23
9704000099488510 -3544,39
9704000099488520 -2133,55
9704000099488600 -39,47
9704000099888510 -6461,63
9704000099888520 -6713
9706000091487110 -24975,15
9706000091488110 -12618,31
9706000091788110 -17921,16
9706000091888110 -4915,02
9706000099488110 -4240,5
9706000099888110 -6923,4
9707400091487010 -63302,91
9707400091487090 -927,64
9707400091487440 -38,6
9707400091487450 -19,47
9707400091488010 -8441,95
9707400091488090 -788,26
9707400091488440 -49,32
9707400091488450 -835,39
9707400091488500 -1751,27
9707400091788010 -7959,51
9707400091788090 -1102,23
9707400091788440 -34,7
9707400091788450 -1256,79
9707400091788500 -117,78
9707400091888010 -10019,86
9707400091888090 -456,86
9707400091888440 -76,87
9707400091888450 -1089,57
9707400091888500 -2981,7
9707400099488010 -333,19
9707400099488090 -5990,01
9707400099488440 -6,39
9707400099488450 -344,31
9707400099488500 -1187,6
9707400099888010 -1228,83
9707400099888090 -11627,02
9707400099888440 -4,9
9707400099888450 -1181,1
9707400099888500 -3283,42
VA00000000000008 -34495,52
VA00000000000012 -136146,2
VA00000000000016 -275362,68
VA00000000000020 17
VA00000000000036 -97595,18
VA00000000000040 -90598,63
VA00000000000080 -1
VA00000000000092 -1
VA00000000000096 -1
VA00000000000100 -1
VA00000000000104 -1
VA00000000000108 -62888,22
VA00000000000112 -36331,26
VA00000000000337 -1
VA00000000000730 -344484,99
VA00000000000762 -1
VA00000000002584 -20189,83
VA00000000002829 -57368,86
VA00000000020463 3
XXY11655F0805
les comptes qui doivent s 'ajouter sont les compte comptable suivi
d'analytique ex :
7070003091310100 c'est le 91310100 qui est le compte analytique qui doit
servir de reference. (le tableau de bord est sur la feuille "VN" et la
table sur la "feuil1"
merci
"ru-th" a écrit dans le message de news:
%salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" a écrit dans le message de
news:434bd700$0$8932$euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au
compte
913101s'ajoute (ici 67 000)
merci d'avance
Bonjour
=SOMMEPROD((DROITE(A2:A641;8)="91310100")*(B2:B641))
donne -65104,53 est-ce le résultat que tu souhaites ?
Stéphane
"lolo" <annaig.laurent@free.fr> a écrit dans le message de news:
434cb320$0$7364$636a55ce@news.free.fr...
bonjour voici ma table :
CELLULE EUR
8 8
12 32
16 34
28 52
36 49
40 14
96 5
108 5
112 14
730 169
762 36
816 9
817 15
818 13
819 31
820 52218
821 57786
822 68494,35
823 179032,66
1186 4068,7
1190 1414,27
1194 596,57
1234 6178,26
1235 5602,54
1238 2667
1239 953
1240 487
1570 68
1636 1
1639 3
1640 1
1641 1
1647 1
1650 1
1654 2
1657 7
1659 2
1673 2
1675 1
1684 1
1685 1
1686 2
1807 4
2200 4160
2584 1
2829 3
1013000000000000 -75000
1061000000000000 -7622,45
1062000000000000 -1224,51
1068000000000000 -386038,37
1200000000000000 -88370,85
1450000000000000 -458,77
1641300000000000 -208775,49
1641310000000000 -6398,74
1641320000000000 -11305,54
1641330000000000 -1874,57
1641340000000000 -1886,33
1641600000000000 -14098,56
1642000000000000 -49978,05
1642100000000000 -69030,17
1642200000000000 -83608,86
1642400000000000 -63862,28
1642600000000000 -15634,66
1642700000000000 -15888,24
1647000000000000 -76224,51
1688000000000000 -2482,62
2050000000000000 32978,9
2115000000000000 129581,66
2131000000000000 648007,13
2135000000000000 21225,02
2154000000000000 115370,92
2181000000000000 80652,84
2182000000000000 2185,19
2183000000000000 6553,88
2183100000000000 73376,84
2184000000000000 25117,3
2610000000000000 6750
2750000000000000 28059,4
2805000000000000 -14795,47
2813100000000000 -333005,28
2813500000000000 -6778,69
2815400000000000 -94059,45
2818100000000000 -53725,38
2818200000000000 -2185,19
2818300000000000 -4932,28
2818310000000000 -54805,51
2818400000000000 -19678,24
3710000000000000 34498,52
3710100000000000 136155,2
3710200000000000 57370,86
3710300000000000 275389,68
3710400000000000 352987,98
3710500000000000 97620,18
3710600000000000 90604,63
3710700000000000 20189,83
3711100000000000 11704,65
3716000000000000 62887,22
3716100000000000 36333,26
3740000000000000 204356,44
3771000000000000 125631,07
3772000000000000 241653,1
3972000000000000 -12400
3974000000000000 -26325,98
3977100000000000 -7300
3977200000000000 -24558
4011000000000000 -44096,72
4012100000000000 -948368,27
4012200000000000 -127069,94
4082000000000000 -27735,13
4083000000000000 -31180,77
4098000000000000 19310,17
4098200000000000 37507,59
4111000000000000 166897,9
4160000000000000 758,33
4183000000000000 352,4
4184000000000000 23823,1
4210000000000000 -11387,94
4251000000000000 250
4282000000000000 -38618,66
4310000000000000 -20045,52
4370000000000000 -3082,97
4373000000000000 -13272,13
4375000000000000 425,2
4382000000000000 -16303,77
4387000000000000 2135,75
4421001000000000 -835
4421002000000000 864
4440000000000000 24090,61
4456200000000000 0,38
4456600000000000 -0,47
4456610000000000 -138
4456700000000000 37457
4457050000000000 -0,24
4457060000000000 -0,12
4457130000000000 138
4457170000000000 -0,98
4458300000000000 7556,51
4458400000000000 -0,25
4458600000000000 206,05
4458700000000000 -13264,69
4486000000000000 -28501,88
4487000000000000 17805,33
4510000000000000 136183
4518000000000000 6096
4553100000000000 -36039,6
4553200000000000 -258323,54
4553400000000000 -12,2
4553500000000000 -12,2
4553600000000000 -12,2
4555000000000000 1067,14
4570000000000000 59992
4613001000000000 -1428
4710000000000000 12,5
4860000000000000 15214,85
4916000000000000 -620,55
5120000000000000 48921,92
5121000000000000 1596,63
5123000000000000 -123657
5171000000000000 2719,24
5186000000000000 -19,23
5300000000000000 782,3
5310000000000000 -443,95
6037100000000000 -6972,41
6037101000000000 -48537,65
6037102000000000 -30360,26
6037103000000000 79694,5
6037104000000000 -93638,44
6037105000000000 328398,6
6037106000000000 22187,34
6037107000000000 -20189,83
6037111000000000 19779,22
6037160000000000 -20978,1
6037161000000000 -3576,86
6037400000000000 -20717,42
6037710000000000 113126,06
6037720000000000 -5339,4
6041100000000000 118,25
6041110000000000 26986,45
6041120000000000 59614,51
6041130000000000 2019,67
6041500000000000 197
6042000000000000 11935,08
6044000000000000 3030
6045000000000000 5725,77
6061000000000000 853,53
6061100000000000 7772,23
6062000000000000 840,58
6063000000000000 408,86
6063100000000000 1063,8
6063110000000000 48,2
6064000000000000 8137,17
6064100000000000 2670,54
6064200000000000 273
6065000000000000 2693,91
6065100000000000 727,3
6067000000000000 5386,15
6067100000000000 236,94
6067200000000000 63,55
6068000000000000 7671,99
6068100000000000 439,78
6068110000000000 33,91
6068200000000000 443,95
6068400000000000 8768,96
6068410000000000 1577,53
6069000000000000 5285,51
6071000000000000 79237,14
6071010000000000 397667,39
6071020000000000 43207,11
6071030000000000 446312
6071040000000000 890322,38
6071050000000000 671217,03
6071060000000000 246608,11
6071070000000000 40629,87
6071110000000000 32820,77
6071600000000000 137080,05
6071610000000000 271459,26
6072000000000000 8849,96
6072010000000000 63390,55
6072020000000000 28804,75
6072030000000000 62530,02
6072040000000000 95147,18
6072050000000000 19309,96
6072060000000000 35997,43
6072510000000000 11704,65
6072610000000000 20832,65
6074000000000000 92034,78
6074100000000000 -818
6074300000000000 147560,1
6074400000000000 190978,51
6074500000000000 5767,95
6074600000000000 3628
6075000000000000 5828,68
6075100000000000 63898,48
6076000000000000 36175,36
6076100000000000 237,96
6076200000000000 5514,27
6076300000000000 4721,26
6076400000000000 8879,19
6077010000000000 635067,66
6077020000000000 86158,39
6077030000000000 529862,11
6077040000000000 30903,01
6077400000000000 23,71
6097100000000000 -3048,39
6097101000000000 -17544,81
6097102000000000 -1697,33
6097103000000000 -24126,2
6097104000000000 -28387,2
6097105000000000 -49315,65
6097106000000000 -23335,1
6097107000000000 -2164,21
6097111000000000 -695
6097151000000000 -3848,45
6097153000000000 -3342,22
6097160000000000 -14406,03
6097161000000000 -33957,19
6097200000000000 -88900
6097400000000000 -25335,17
6097500000000000 -636,8
6097600000000000 -3170,97
6112000000000000 303,21
6131000000000000 1636,23
6131100000000000 38,52
6132000000000000 375
6133000000000000 29946,95
6138000000000000 447,04
6152000000000000 610,46
6152100000000000 4542,47
6153000000000000 2553,89
6153100000000000 8245,67
6153200000000000 1882,84
6155000000000000 752,4
6155800000000000 58
6162000000000000 11263,08
6165000000000000 670,34
6167000000000000 262,5
6180000000000000 312,24
6182000000000000 134,62
6183000000000000 280,29
6222000000000000 1285,29
6223000000000000 460
6224000000000000 108
6226000000000000 7736
6227000000000000 245,11
6228000000000000 1529,64
6228100000000000 9,17
6230000000000000 341,64
6231000000000000 24828,41
6231100000000000 44,14
6232000000000000 6828,22
6233000000000000 270,9
6234000000000000 2796,44
6238000000000000 215
6241000000000000 1774,42
6242000000000000 4275,36
6244000000000000 356,2
6251100000000000 1367,98
6251200000000000 131,36
6251300000000000 8,36
6251400000000000 33,45
6256100000000000 588,98
6261000000000000 2708,61
6261100000000000 1653,38
6261120000000000 400
6262000000000000 6279,46
6262500000000000 304
6263000000000000 3526,29
6270000000000000 3050,41
6271100000000000 1538,86
6272000000000000 92
6278000000000000 20
6281000000000000 2899,33
6312000000000000 2043,64
6313000000000000 7311,91
6314000000000000 1781,81
6351100000000000 13026,3
6351200000000000 5039,33
6353100000000000 1930
6353110000000000 3937
6353120000000000 250
6353140000000000 338,76
6371000000000000 8389,42
6411000000000000 21320,08
6411010000000000 79693,61
6411040000000000 25171,71
6411050000000000 14253,43
6411060000000000 41800,91
6411070000000000 8022,48
6411080000000000 14748,5
6411090000000000 34935,47
6411100000000000 24201,3
6411110000000000 44351
6411120000000000 14074,5
6411130000000000 41575,18
6411140000000000 39476,34
6412000000000000 -132
6412010000000000 -4230,62
6412040000000000 3042,41
6412050000000000 -2653,96
6412060000000000 -1179,48
6412070000000000 -802,5
6412090000000000 -1014,46
6412120000000000 -651,84
6412130000000000 1695,6
6417070000000000 648
6417090000000000 648
6417100000000000 1944
6417140000000000 960
6417170000000000 -648
6417190000000000 -648
6417200000000000 -1944
6417240000000000 -960
6451000000000000 6921,45
6451010000000000 12418,99
6451040000000000 7506,61
6451050000000000 1392,34
6451060000000000 10778,68
6451070000000000 7226,9
6451090000000000 32469,75
6451120000000000 3567,04
6451130000000000 12654,26
6451140000000000 11227,29
6452000000000000 929,55
6452010000000000 3120,81
6452040000000000 1239,16
6452050000000000 509,86
6452060000000000 1781,55
6452070000000000 991,91
6452090000000000 4610,83
6452120000000000 588,28
6452130000000000 1896,78
6453000000000000 1796,87
6453010000000000 5843,93
6453040000000000 2685,18
6453050000000000 968,64
6453060000000000 3604,07
6453070000000000 1988,5
6453090000000000 11713,9
6453120000000000 1080
6453130000000000 4374,12
6453140000000000 5866,5
6453310000000000 3000,19
6454000000000000 -2,64
6454010000000000 -84,62
6454040000000000 60,85
6454050000000000 -53,08
6454060000000000 -73,59
6454070000000000 -16,05
6454090000000000 -20,29
6454120000000000 -13,03
6454130000000000 -16,09
6475000000000000 2206,05
6481000000000000 180
6481900000000000 90
6510000000000000 209,11
6530000000000000 7500
6540000000000000 400
6580000000000000 29,35
6611000000000000 16141,6
6615000000000000 -12404,47
6616100000000000 2778,18
6616200000000000 4855,01
6712000000000000 245
6720000000000000 14551
6811100000000000 5167,99
6811210000000000 30033,14
6811220000000000 9775,42
6811240000000000 5607,36
7040001091489520 -2068,01
7040001099489510 -770,91
7040003091426510 -15,05
7040003091426520 -112,3
7040003091489510 -4168,07
7040003091489520 -45465,1
7040003091489600 -2086,82
7040003099426510 -279,25
7040003099426520 -254,35
7040003099489510 -570,29
7040003099489520 -2221,08
7040003099489600 -127,93
7040004000000000 -3020,28
7040004100000000 -733,25
7045003000000000 -7569,55
7060001091489110 -2356,87
7060001099489110 -878,58
7060003091426110 -48,15
7060003091489110 -162266,72
7060003099426110 -668,1
7060003099489110 -4221,18
7063003000000000 -3970,22
7066003000000000 -22883,75
7070003091310100 -71124,61
7070003091310200 -313754,71
7070003091310300 -411961,1
7070003091310400 -735821,5
7070003091310600 -842671,65
7070003091310700 -246070,23
7070003091311600 -32441,47
7070003091311900 -38787,02
7070003091312200 -110782,11
7070003091312300 -271510,08
7070003091315500 -35017,01
7070003091315600 -592422,08
7070003091319200 -24046,82
7070003091330100 -9531,77
7070003091330200 -43257,02
7070003091330300 -86137,12
7070003091330400 -190170,55
7070003091330600 -129991,61
7070003091330700 -59277,6
7070003091331600 -13478,26
7070003091331900 -17160,45
7070003091332300 -19648,83
7074001091489010 -7303,65
7074001091489090 -148,58
7074001091489530 -787,52
7074001099489010 -0,52
7074001099489090 -3922,17
7074001099489450 -92,06
7074003091102010 -257943,27
7074003091102440 -109,04
7074003091102500 -273,6
7074003091104010 -2161,78
7074003091126010 -16157,85
7074003091126440 -24,85
7074003091126500 -86,04
7074003091189010 -53329,33
7074003091189440 -291,2
7074003091189500 -1887,59
7074003091426010 -182,23
7074003091426090 -51
7074003091489010 -227177,94
7074003091489090 -19576,21
7074003091489440 -1271,49
7074003091489500 -17925,92
7074003099102010 -8608,24
7074003099126010 -2042,5
7074003099189010 -7174,65
7074003099189450 -2051,2
7074003099426010 -207,39
7074003099426090 -270,29
7074003099426450 -51,48
7074003099489010 -765,81
7074003099489090 -4443,4
7074003099489440 -23,44
7074003099489450 -28879,34
7074003099489500 -218,6
7074003600000000 -346,04
7074103000000000 -14661,67
7074203000000000 -1627,98
7074403000000000 -98,43
7074703000000000 -57865,82
7077001091322700 -814759,62
7077001091372700 -55180,01
7077001099322700 -581148,98
7077001099372700 -60316
7077003091322700 -99518,46
7077003099322700 -5311,87
7077008000000000 -5942,57
7077020091322700 37275,67
7082008000000000 -1095,74
7082103000000000 -3068,03
7082108000000000 -6236,06
7082109000000000 -2184,2
7082203000000000 -150
7082203100000000 -238,29
7083003091489250 -870,32
7083003099489250 -41,8
7083203000000000 -300,46
7085103000000000 -4125,73
7087113000000000 3678,05
7094003091489520 78,12
7096001091489110 12,22
7096003091489110 132,01
7096003099489110 -43,78
7097003091310100 6020,08
7097003091310200 30284,64
7097003091310300 40404,46
7097003091310400 69853,96
7097003091310600 104043,69
7097003091310700 38178,92
7097003091311600 1895,48
7097003091311900 6952,01
7097003091312200 25095,53
7097003091312300 63945,55
7097003091319200 4531,25
7097003091330200 6657,39
7097003091330300 6452,34
7097003091330400 21868,73
7097003091330600 12611,21
7097003091330700 4757,53
7097401091489010 57,37
7097401091489090 26,31
7097403091102010 67733,2
7097403091102440 18,57
7097403091102500 27,36
7097403091104010 146,52
7097403091126010 9,8
7097403091189010 5292,86
7097403091189440 20,32
7097403091189500 72,68
7097403091489010 6479,66
7097403091489090 393,13
7097403091489440 16,98
7097403091489450 198,48
7097403091489500 2286,31
7097403099102010 1300,93
7097403099189010 126,24
7097403099189450 188,92
7097403099489010 1,68
7097403099489090 37,98
7097403099489450 16,23
7580000000000000 705
7720000000000000 -10490,91
7720003000000000 -373,92
7914100000000000 -3103,13
7914200000000000 -918,72
7916200000000000 -1718,19
7916300000000000 -716,25
9415500000000000 90944,75
9415500100000000 26963,79
9415500200000000 3678,84
9415500300000000 208,4
9415500500000000 8957,63
9415500600000000 4940,74
9415500700000000 567,56
9415500800000000 9812,08
9415501200000000 2975,5
9415501300000000 490,71
9417000000000000 91932,09
9704000091487510 -2642,32
9704000091487520 -26
9704000091488510 -1612,55
9704000091488520 -4921,41
9704000091488600 -150,66
9704000091788510 -2214,5
9704000091788520 -1867,05
9704000091888510 -5796,69
9704000091888520 -5247,65
9704000091888600 -70,23
9704000099488510 -3544,39
9704000099488520 -2133,55
9704000099488600 -39,47
9704000099888510 -6461,63
9704000099888520 -6713
9706000091487110 -24975,15
9706000091488110 -12618,31
9706000091788110 -17921,16
9706000091888110 -4915,02
9706000099488110 -4240,5
9706000099888110 -6923,4
9707400091487010 -63302,91
9707400091487090 -927,64
9707400091487440 -38,6
9707400091487450 -19,47
9707400091488010 -8441,95
9707400091488090 -788,26
9707400091488440 -49,32
9707400091488450 -835,39
9707400091488500 -1751,27
9707400091788010 -7959,51
9707400091788090 -1102,23
9707400091788440 -34,7
9707400091788450 -1256,79
9707400091788500 -117,78
9707400091888010 -10019,86
9707400091888090 -456,86
9707400091888440 -76,87
9707400091888450 -1089,57
9707400091888500 -2981,7
9707400099488010 -333,19
9707400099488090 -5990,01
9707400099488440 -6,39
9707400099488450 -344,31
9707400099488500 -1187,6
9707400099888010 -1228,83
9707400099888090 -11627,02
9707400099888440 -4,9
9707400099888450 -1181,1
9707400099888500 -3283,42
VA00000000000008 -34495,52
VA00000000000012 -136146,2
VA00000000000016 -275362,68
VA00000000000020 17
VA00000000000036 -97595,18
VA00000000000040 -90598,63
VA00000000000080 -1
VA00000000000092 -1
VA00000000000096 -1
VA00000000000100 -1
VA00000000000104 -1
VA00000000000108 -62888,22
VA00000000000112 -36331,26
VA00000000000337 -1
VA00000000000730 -344484,99
VA00000000000762 -1
VA00000000002584 -20189,83
VA00000000002829 -57368,86
VA00000000020463 3
XXY11655F0805
les comptes qui doivent s 'ajouter sont les compte comptable suivi
d'analytique ex :
7070003091310100 c'est le 91310100 qui est le compte analytique qui doit
servir de reference. (le tableau de bord est sur la feuille "VN" et la
table sur la "feuil1"
merci
"ru-th" <ailleurs@nowhere.fr> a écrit dans le message de news:
%23sxHIenzFHA.2076@TK2MSFTNGP14.phx.gbl...
salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bd700$0$8932$626a14ce@news.free.fr...
euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" <ailleurs@nowhere.fr> a écrit dans le message de news:
%23cysf%23mzFHA.3152@TK2MSFTNGP10.phx.gbl...
Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" <annaig.laurent@free.fr> a écrit dans le message de
news:434bb57a$0$9684$626a14ce@news.free.fr...
RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au
compte
913101
s'ajoute (ici 67 000)
merci d'avance
Bonjour
=SOMMEPROD((DROITE(A2:A641;8)="91310100")*(B2:B641))
donne -65104,53 est-ce le résultat que tu souhaites ?
Stéphane
"lolo" a écrit dans le message de news:
434cb320$0$7364$bonjour voici ma table :
CELLULE EUR
8 8
12 32
16 34
28 52
36 49
40 14
96 5
108 5
112 14
730 169
762 36
816 9
817 15
818 13
819 31
820 52218
821 57786
822 68494,35
823 179032,66
1186 4068,7
1190 1414,27
1194 596,57
1234 6178,26
1235 5602,54
1238 2667
1239 953
1240 487
1570 68
1636 1
1639 3
1640 1
1641 1
1647 1
1650 1
1654 2
1657 7
1659 2
1673 2
1675 1
1684 1
1685 1
1686 2
1807 4
2200 4160
2584 1
2829 3
1013000000000000 -75000
1061000000000000 -7622,45
1062000000000000 -1224,51
1068000000000000 -386038,37
1200000000000000 -88370,85
1450000000000000 -458,77
1641300000000000 -208775,49
1641310000000000 -6398,74
1641320000000000 -11305,54
1641330000000000 -1874,57
1641340000000000 -1886,33
1641600000000000 -14098,56
1642000000000000 -49978,05
1642100000000000 -69030,17
1642200000000000 -83608,86
1642400000000000 -63862,28
1642600000000000 -15634,66
1642700000000000 -15888,24
1647000000000000 -76224,51
1688000000000000 -2482,62
2050000000000000 32978,9
2115000000000000 129581,66
2131000000000000 648007,13
2135000000000000 21225,02
2154000000000000 115370,92
2181000000000000 80652,84
2182000000000000 2185,19
2183000000000000 6553,88
2183100000000000 73376,84
2184000000000000 25117,3
2610000000000000 6750
2750000000000000 28059,4
2805000000000000 -14795,47
2813100000000000 -333005,28
2813500000000000 -6778,69
2815400000000000 -94059,45
2818100000000000 -53725,38
2818200000000000 -2185,19
2818300000000000 -4932,28
2818310000000000 -54805,51
2818400000000000 -19678,24
3710000000000000 34498,52
3710100000000000 136155,2
3710200000000000 57370,86
3710300000000000 275389,68
3710400000000000 352987,98
3710500000000000 97620,18
3710600000000000 90604,63
3710700000000000 20189,83
3711100000000000 11704,65
3716000000000000 62887,22
3716100000000000 36333,26
3740000000000000 204356,44
3771000000000000 125631,07
3772000000000000 241653,1
3972000000000000 -12400
3974000000000000 -26325,98
3977100000000000 -7300
3977200000000000 -24558
4011000000000000 -44096,72
4012100000000000 -948368,27
4012200000000000 -127069,94
4082000000000000 -27735,13
4083000000000000 -31180,77
4098000000000000 19310,17
4098200000000000 37507,59
4111000000000000 166897,9
4160000000000000 758,33
4183000000000000 352,4
4184000000000000 23823,1
4210000000000000 -11387,94
4251000000000000 250
4282000000000000 -38618,66
4310000000000000 -20045,52
4370000000000000 -3082,97
4373000000000000 -13272,13
4375000000000000 425,2
4382000000000000 -16303,77
4387000000000000 2135,75
4421001000000000 -835
4421002000000000 864
4440000000000000 24090,61
4456200000000000 0,38
4456600000000000 -0,47
4456610000000000 -138
4456700000000000 37457
4457050000000000 -0,24
4457060000000000 -0,12
4457130000000000 138
4457170000000000 -0,98
4458300000000000 7556,51
4458400000000000 -0,25
4458600000000000 206,05
4458700000000000 -13264,69
4486000000000000 -28501,88
4487000000000000 17805,33
4510000000000000 136183
4518000000000000 6096
4553100000000000 -36039,6
4553200000000000 -258323,54
4553400000000000 -12,2
4553500000000000 -12,2
4553600000000000 -12,2
4555000000000000 1067,14
4570000000000000 59992
4613001000000000 -1428
4710000000000000 12,5
4860000000000000 15214,85
4916000000000000 -620,55
5120000000000000 48921,92
5121000000000000 1596,63
5123000000000000 -123657
5171000000000000 2719,24
5186000000000000 -19,23
5300000000000000 782,3
5310000000000000 -443,95
6037100000000000 -6972,41
6037101000000000 -48537,65
6037102000000000 -30360,26
6037103000000000 79694,5
6037104000000000 -93638,44
6037105000000000 328398,6
6037106000000000 22187,34
6037107000000000 -20189,83
6037111000000000 19779,22
6037160000000000 -20978,1
6037161000000000 -3576,86
6037400000000000 -20717,42
6037710000000000 113126,06
6037720000000000 -5339,4
6041100000000000 118,25
6041110000000000 26986,45
6041120000000000 59614,51
6041130000000000 2019,67
6041500000000000 197
6042000000000000 11935,08
6044000000000000 3030
6045000000000000 5725,77
6061000000000000 853,53
6061100000000000 7772,23
6062000000000000 840,58
6063000000000000 408,86
6063100000000000 1063,8
6063110000000000 48,2
6064000000000000 8137,17
6064100000000000 2670,54
6064200000000000 273
6065000000000000 2693,91
6065100000000000 727,3
6067000000000000 5386,15
6067100000000000 236,94
6067200000000000 63,55
6068000000000000 7671,99
6068100000000000 439,78
6068110000000000 33,91
6068200000000000 443,95
6068400000000000 8768,96
6068410000000000 1577,53
6069000000000000 5285,51
6071000000000000 79237,14
6071010000000000 397667,39
6071020000000000 43207,11
6071030000000000 446312
6071040000000000 890322,38
6071050000000000 671217,03
6071060000000000 246608,11
6071070000000000 40629,87
6071110000000000 32820,77
6071600000000000 137080,05
6071610000000000 271459,26
6072000000000000 8849,96
6072010000000000 63390,55
6072020000000000 28804,75
6072030000000000 62530,02
6072040000000000 95147,18
6072050000000000 19309,96
6072060000000000 35997,43
6072510000000000 11704,65
6072610000000000 20832,65
6074000000000000 92034,78
6074100000000000 -818
6074300000000000 147560,1
6074400000000000 190978,51
6074500000000000 5767,95
6074600000000000 3628
6075000000000000 5828,68
6075100000000000 63898,48
6076000000000000 36175,36
6076100000000000 237,96
6076200000000000 5514,27
6076300000000000 4721,26
6076400000000000 8879,19
6077010000000000 635067,66
6077020000000000 86158,39
6077030000000000 529862,11
6077040000000000 30903,01
6077400000000000 23,71
6097100000000000 -3048,39
6097101000000000 -17544,81
6097102000000000 -1697,33
6097103000000000 -24126,2
6097104000000000 -28387,2
6097105000000000 -49315,65
6097106000000000 -23335,1
6097107000000000 -2164,21
6097111000000000 -695
6097151000000000 -3848,45
6097153000000000 -3342,22
6097160000000000 -14406,03
6097161000000000 -33957,19
6097200000000000 -88900
6097400000000000 -25335,17
6097500000000000 -636,8
6097600000000000 -3170,97
6112000000000000 303,21
6131000000000000 1636,23
6131100000000000 38,52
6132000000000000 375
6133000000000000 29946,95
6138000000000000 447,04
6152000000000000 610,46
6152100000000000 4542,47
6153000000000000 2553,89
6153100000000000 8245,67
6153200000000000 1882,84
6155000000000000 752,4
6155800000000000 58
6162000000000000 11263,08
6165000000000000 670,34
6167000000000000 262,5
6180000000000000 312,24
6182000000000000 134,62
6183000000000000 280,29
6222000000000000 1285,29
6223000000000000 460
6224000000000000 108
6226000000000000 7736
6227000000000000 245,11
6228000000000000 1529,64
6228100000000000 9,17
6230000000000000 341,64
6231000000000000 24828,41
6231100000000000 44,14
6232000000000000 6828,22
6233000000000000 270,9
6234000000000000 2796,44
6238000000000000 215
6241000000000000 1774,42
6242000000000000 4275,36
6244000000000000 356,2
6251100000000000 1367,98
6251200000000000 131,36
6251300000000000 8,36
6251400000000000 33,45
6256100000000000 588,98
6261000000000000 2708,61
6261100000000000 1653,38
6261120000000000 400
6262000000000000 6279,46
6262500000000000 304
6263000000000000 3526,29
6270000000000000 3050,41
6271100000000000 1538,86
6272000000000000 92
6278000000000000 20
6281000000000000 2899,33
6312000000000000 2043,64
6313000000000000 7311,91
6314000000000000 1781,81
6351100000000000 13026,3
6351200000000000 5039,33
6353100000000000 1930
6353110000000000 3937
6353120000000000 250
6353140000000000 338,76
6371000000000000 8389,42
6411000000000000 21320,08
6411010000000000 79693,61
6411040000000000 25171,71
6411050000000000 14253,43
6411060000000000 41800,91
6411070000000000 8022,48
6411080000000000 14748,5
6411090000000000 34935,47
6411100000000000 24201,3
6411110000000000 44351
6411120000000000 14074,5
6411130000000000 41575,18
6411140000000000 39476,34
6412000000000000 -132
6412010000000000 -4230,62
6412040000000000 3042,41
6412050000000000 -2653,96
6412060000000000 -1179,48
6412070000000000 -802,5
6412090000000000 -1014,46
6412120000000000 -651,84
6412130000000000 1695,6
6417070000000000 648
6417090000000000 648
6417100000000000 1944
6417140000000000 960
6417170000000000 -648
6417190000000000 -648
6417200000000000 -1944
6417240000000000 -960
6451000000000000 6921,45
6451010000000000 12418,99
6451040000000000 7506,61
6451050000000000 1392,34
6451060000000000 10778,68
6451070000000000 7226,9
6451090000000000 32469,75
6451120000000000 3567,04
6451130000000000 12654,26
6451140000000000 11227,29
6452000000000000 929,55
6452010000000000 3120,81
6452040000000000 1239,16
6452050000000000 509,86
6452060000000000 1781,55
6452070000000000 991,91
6452090000000000 4610,83
6452120000000000 588,28
6452130000000000 1896,78
6453000000000000 1796,87
6453010000000000 5843,93
6453040000000000 2685,18
6453050000000000 968,64
6453060000000000 3604,07
6453070000000000 1988,5
6453090000000000 11713,9
6453120000000000 1080
6453130000000000 4374,12
6453140000000000 5866,5
6453310000000000 3000,19
6454000000000000 -2,64
6454010000000000 -84,62
6454040000000000 60,85
6454050000000000 -53,08
6454060000000000 -73,59
6454070000000000 -16,05
6454090000000000 -20,29
6454120000000000 -13,03
6454130000000000 -16,09
6475000000000000 2206,05
6481000000000000 180
6481900000000000 90
6510000000000000 209,11
6530000000000000 7500
6540000000000000 400
6580000000000000 29,35
6611000000000000 16141,6
6615000000000000 -12404,47
6616100000000000 2778,18
6616200000000000 4855,01
6712000000000000 245
6720000000000000 14551
6811100000000000 5167,99
6811210000000000 30033,14
6811220000000000 9775,42
6811240000000000 5607,36
7040001091489520 -2068,01
7040001099489510 -770,91
7040003091426510 -15,05
7040003091426520 -112,3
7040003091489510 -4168,07
7040003091489520 -45465,1
7040003091489600 -2086,82
7040003099426510 -279,25
7040003099426520 -254,35
7040003099489510 -570,29
7040003099489520 -2221,08
7040003099489600 -127,93
7040004000000000 -3020,28
7040004100000000 -733,25
7045003000000000 -7569,55
7060001091489110 -2356,87
7060001099489110 -878,58
7060003091426110 -48,15
7060003091489110 -162266,72
7060003099426110 -668,1
7060003099489110 -4221,18
7063003000000000 -3970,22
7066003000000000 -22883,75
7070003091310100 -71124,61
7070003091310200 -313754,71
7070003091310300 -411961,1
7070003091310400 -735821,5
7070003091310600 -842671,65
7070003091310700 -246070,23
7070003091311600 -32441,47
7070003091311900 -38787,02
7070003091312200 -110782,11
7070003091312300 -271510,08
7070003091315500 -35017,01
7070003091315600 -592422,08
7070003091319200 -24046,82
7070003091330100 -9531,77
7070003091330200 -43257,02
7070003091330300 -86137,12
7070003091330400 -190170,55
7070003091330600 -129991,61
7070003091330700 -59277,6
7070003091331600 -13478,26
7070003091331900 -17160,45
7070003091332300 -19648,83
7074001091489010 -7303,65
7074001091489090 -148,58
7074001091489530 -787,52
7074001099489010 -0,52
7074001099489090 -3922,17
7074001099489450 -92,06
7074003091102010 -257943,27
7074003091102440 -109,04
7074003091102500 -273,6
7074003091104010 -2161,78
7074003091126010 -16157,85
7074003091126440 -24,85
7074003091126500 -86,04
7074003091189010 -53329,33
7074003091189440 -291,2
7074003091189500 -1887,59
7074003091426010 -182,23
7074003091426090 -51
7074003091489010 -227177,94
7074003091489090 -19576,21
7074003091489440 -1271,49
7074003091489500 -17925,92
7074003099102010 -8608,24
7074003099126010 -2042,5
7074003099189010 -7174,65
7074003099189450 -2051,2
7074003099426010 -207,39
7074003099426090 -270,29
7074003099426450 -51,48
7074003099489010 -765,81
7074003099489090 -4443,4
7074003099489440 -23,44
7074003099489450 -28879,34
7074003099489500 -218,6
7074003600000000 -346,04
7074103000000000 -14661,67
7074203000000000 -1627,98
7074403000000000 -98,43
7074703000000000 -57865,82
7077001091322700 -814759,62
7077001091372700 -55180,01
7077001099322700 -581148,98
7077001099372700 -60316
7077003091322700 -99518,46
7077003099322700 -5311,87
7077008000000000 -5942,57
7077020091322700 37275,67
7082008000000000 -1095,74
7082103000000000 -3068,03
7082108000000000 -6236,06
7082109000000000 -2184,2
7082203000000000 -150
7082203100000000 -238,29
7083003091489250 -870,32
7083003099489250 -41,8
7083203000000000 -300,46
7085103000000000 -4125,73
7087113000000000 3678,05
7094003091489520 78,12
7096001091489110 12,22
7096003091489110 132,01
7096003099489110 -43,78
7097003091310100 6020,08
7097003091310200 30284,64
7097003091310300 40404,46
7097003091310400 69853,96
7097003091310600 104043,69
7097003091310700 38178,92
7097003091311600 1895,48
7097003091311900 6952,01
7097003091312200 25095,53
7097003091312300 63945,55
7097003091319200 4531,25
7097003091330200 6657,39
7097003091330300 6452,34
7097003091330400 21868,73
7097003091330600 12611,21
7097003091330700 4757,53
7097401091489010 57,37
7097401091489090 26,31
7097403091102010 67733,2
7097403091102440 18,57
7097403091102500 27,36
7097403091104010 146,52
7097403091126010 9,8
7097403091189010 5292,86
7097403091189440 20,32
7097403091189500 72,68
7097403091489010 6479,66
7097403091489090 393,13
7097403091489440 16,98
7097403091489450 198,48
7097403091489500 2286,31
7097403099102010 1300,93
7097403099189010 126,24
7097403099189450 188,92
7097403099489010 1,68
7097403099489090 37,98
7097403099489450 16,23
7580000000000000 705
7720000000000000 -10490,91
7720003000000000 -373,92
7914100000000000 -3103,13
7914200000000000 -918,72
7916200000000000 -1718,19
7916300000000000 -716,25
9415500000000000 90944,75
9415500100000000 26963,79
9415500200000000 3678,84
9415500300000000 208,4
9415500500000000 8957,63
9415500600000000 4940,74
9415500700000000 567,56
9415500800000000 9812,08
9415501200000000 2975,5
9415501300000000 490,71
9417000000000000 91932,09
9704000091487510 -2642,32
9704000091487520 -26
9704000091488510 -1612,55
9704000091488520 -4921,41
9704000091488600 -150,66
9704000091788510 -2214,5
9704000091788520 -1867,05
9704000091888510 -5796,69
9704000091888520 -5247,65
9704000091888600 -70,23
9704000099488510 -3544,39
9704000099488520 -2133,55
9704000099488600 -39,47
9704000099888510 -6461,63
9704000099888520 -6713
9706000091487110 -24975,15
9706000091488110 -12618,31
9706000091788110 -17921,16
9706000091888110 -4915,02
9706000099488110 -4240,5
9706000099888110 -6923,4
9707400091487010 -63302,91
9707400091487090 -927,64
9707400091487440 -38,6
9707400091487450 -19,47
9707400091488010 -8441,95
9707400091488090 -788,26
9707400091488440 -49,32
9707400091488450 -835,39
9707400091488500 -1751,27
9707400091788010 -7959,51
9707400091788090 -1102,23
9707400091788440 -34,7
9707400091788450 -1256,79
9707400091788500 -117,78
9707400091888010 -10019,86
9707400091888090 -456,86
9707400091888440 -76,87
9707400091888450 -1089,57
9707400091888500 -2981,7
9707400099488010 -333,19
9707400099488090 -5990,01
9707400099488440 -6,39
9707400099488450 -344,31
9707400099488500 -1187,6
9707400099888010 -1228,83
9707400099888090 -11627,02
9707400099888440 -4,9
9707400099888450 -1181,1
9707400099888500 -3283,42
VA00000000000008 -34495,52
VA00000000000012 -136146,2
VA00000000000016 -275362,68
VA00000000000020 17
VA00000000000036 -97595,18
VA00000000000040 -90598,63
VA00000000000080 -1
VA00000000000092 -1
VA00000000000096 -1
VA00000000000100 -1
VA00000000000104 -1
VA00000000000108 -62888,22
VA00000000000112 -36331,26
VA00000000000337 -1
VA00000000000730 -344484,99
VA00000000000762 -1
VA00000000002584 -20189,83
VA00000000002829 -57368,86
VA00000000020463 3
XXY11655F0805
les comptes qui doivent s 'ajouter sont les compte comptable suivi
d'analytique ex :
7070003091310100 c'est le 91310100 qui est le compte analytique qui doit
servir de reference. (le tableau de bord est sur la feuille "VN" et la
table sur la "feuil1"
merci
"ru-th" a écrit dans le message de news:
%salut
tes comptes sont toujours dans le même position : d'ailleurs 8 ou 9ème
position le 1ère caractère du compte ?
et ils ont toujours du même longueur de 6 ?
parce que, en principe, ...cela doit le faire
a+
rural thierry
"lolo" a écrit dans le message de
news:434bd700$0$8932$euh ca marche pas j'ai mis
=sommeprod((stxt(feuil1!a1:a641;8;6)="913101")*feuil1!b1*b641
merci
"ru-th" a écrit dans le message de news:
%23cysf%Salut
=SOMMEPROD((STXT(A1:A50;9;6)="913101")*C1:C50)
a+
rural thierry
"lolo" a écrit dans le message de
news:434bb57a$0$9684$RE...
voici ma table
7070003091310100 77000
7097003091310100 -10000
....
je voudrais que toutes les sommes se referent dans ma table au
compte
913101s'ajoute (ici 67 000)
merci d'avance
