summing a dynamical range with IF

[peterschein]

Dear Professionals,


I wrote a code to sum values of a column if some criterias are met but I can not make it dynamic.

can you please help me? I also uploaded the file.

i assume the red areas need to be different..

Please Login or Register  to view this content.

As it is one of my first codes I would appriciate if you could solve this with as little changes as possible that I will fully understand it
I know it is totally not elegant way of doing but i am on a learning curve


thank you indeed for your kind help!
best regards
Peter

[Fluff13]

How about

Please Login or Register  to view this content.

[peterschein]

thank you Fluff13 I will try to understand it but true dimming the sheets is a good idea!

[Fluff13]

You're welcome & thanks for the feedback.
For info on dictionaries have a look here https://excelmacromastery.com/vba-dictionary/

[peterschein]

thank you! on Sunday I will examine your code in depth have a nice weekend!

[Fluff13]

And you
Cheers

[peterschein]

Dear Fluff13


one more question please.

do I understand it correctly?


it loops through the range and .Item(Cl.Value) works as a basket.
it checks the content of the first cells value (3c60 in that case) and that is basket one..and then puts the offsetted cells value in basket 3c60.

in the second loop it jumps one cell down and checks its value.. if its 3c60 again its value will be incremented with the offsetted cells value

If it is not 3c60 but an other item it understands as a new basket and collects the new offsetted values to it and will be basket 2

and so on ...


My question is:


in the other sheet ("artikel") the items must be in the same order as in sheet ("source").. is it right?

because the code sorts like A2--> basket 1 value
A3--> basket 2 value
and so on...

not taking into account if A2 is 3c60 or A3.

Is that right? I am just not sure right now if the order of appearances will be always the same in both sheets...

thank you for your answer!

Peter

[Fluff13]

You're understanding is correct, but the order of the values in either sheet does not matter.