As a reminder, I never give any code by PM, you just must create a thread as any forum expects for …
According to your attachment a Collection / Dictionary is a bit superfluous here
as yet stated this can be done just in two Excel basics steps like
any beginner can operate manually via an advanced filter and an easy SUMIFS formula.
So as a beginner starter the VBA demonstration below well works for the smart enough readers,
you just must paste it to the source 'Before' worksheet module (so obviously not in a standard module) :
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » !
Bookmarks