| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summ aumont with interesec 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 | |||
| Summ figures that are not struck-through | Excel Worksheet Functions | |||
| summ aumont with interesection with two index.... | Excel Discussion (Misc queries) | |||
| Rounding decimals in a summ | Excel Discussion (Misc queries) | |||
| How can I use SUMIF and AND to test for two conditons before summ. | Excel Worksheet Functions | |||
| summ gg | Excel Programming | |||
Linear Mode
