| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index / Hlookup | Excel Worksheet Functions | |||
| How to automatically number an index column | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Min formula not returning value from Index | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Linear Mode
