summ aumont with interesection with two index....
With a macro.....please!
In column A of sheet STAT_L0953 have a value and the same value are present also in column A of L0953. In column D of sheet L0953 have a value are present also in line 2 of sheet STAT_L0953. Now intersec the value and summ the value refered the column O (are aumont) put the result of the summ in eache cella basec AG. and value in line 2 of sheet STAT_L0953... Example: AG. = 4500 TIPO SOSP = 146900090000 cell L3 of STAT_L0953 = 4219320,51 AG. = 4503 TIPO SOSP = 111000010000 cell H5 of STAT_L0953 = 2850,00 ecc... here the example file: http://www.mytempdir.com/1176302 tks |
All times are GMT +1. The time now is 03:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com