'Sum table values by both column header title and by date criteria row by row using Application.worksheetfunction.SumProduct

I've a table with multiple columns and multiple rows and i've created a code to sum table values by three criteria ( by column header title - by dates >= lower date - by dates <= upper date ) buy code doesn't run properly and gives me an error and here is the code. any help !!

                TrialBalanceArr(FirstLoop, DebitTransCol) = _
                Application.WorksheetFunction.SumProduct(--( _
                Sheets(EntriesSH).Range(Entriestbl & "[[#Headers],[" & BoxCash & " " & Debit & "]:[" & Diff & "]]") = _
                TrialBalanceArr(FirstLoop, SixthExpCol) & _
                " " & Debit) * ( _
                Sheets(EntriesSH).Range(Entriestbl & "[" & _
                DateEn & "]") >= DateFrom) * ( _
                Sheets(EntriesSH).Range(Entriestbl & "[" & _
                DateEn & "]") <= DateTo) * ( _
                Sheets(EntriesSH).Range(Entriestbl & "[[" & BoxCash & " " & Debit & "]:[" & Diff & "]]")))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Sum table values by both column header title and by date criteria row by row using Application.worksheetfunction.SumProduct

Sources

Related Questions