VBA – Repeat SUMIFS Formula for Unique Combinations of Rows

[msmna93]

Hello everyone.

I am a VBA beginner. I need your help to solve my problem.

Suppose that I have an Excel table with the following fields:

D: Account
L: Amount
M: Category
N: Value Day

What I need to do is the following:

1. Compute the conditional sums of the amounts by all possible unique combinations of accounts, categories and value days that are shown in the table until the Last Row.
2. Store the values coming from point 1 in a 3D array (without printing them in an Excel sheet)

Here is the code where I'd need to build on.

Dim LastRow As Long
LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

Application.WorksheetFunction.Sumifs(Range("L2:L" & LastRow), Range("D2:D" & LastRow), "IBAN N.1", Range("M2:M" & LastRow), "Foreign Receipt", Range("N2:N" & LastRow), "27")

Any help is deeply appreciated.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ns-summary-sheet-post5199849.html#post5199849

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).