summ aumont with interesec two index....

S

sal21

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summ aumont with interesec two index.... 0
summ aumont with interesection with two index.... 0
summ aumont with interesection with two index.... 0
Compare aumont and insert "Balanced"... 0
count value with filter... 0
E_MAIL WITH MATCHING... 0
E_MAIL WITH MATCHING... 0
copy line with 2 condition.... 0

Top