SumIfs VBA formula

[kerstinedatu]

Hi All,

I am currently trying to write a code with SUMIFS formula but I'm having difficulty as I'm still a newbie at VBA.
I tried using other codes from different forums including here but to no avail.
Would also like to know if the code can loop for all blank cells in case other criteria will be added in the future.

Below is a sample of what I'm currently working on.

Sheet 1 (Received) A B C D E F 9 Total 1,312.00 57,206.00 57,206.00 10 Bank 1/1/2018 1/2/2018 1/3/2018 11 JMC JP Morgan Chase 1,000.00 1,000.00 1,000.00 12 BOA Bank of America - 1,000.00 1,000.00 13 CG Citigroup - - - 14 WF Wells Fargo - - - 15 GS Goldman Sachs 312.00 312.00 312.00 16 MS Morgan Stanley - 54,894.00 54,894.00 17 USB U.S Bancorp - - - <colgroup><col><col><col><col span="3"></colgroup><tbody> </tbody>
Sheet 2 (Details) A B C D E 10 Branch Bank Account Cheque Amount Date Received from EO 11 1 JP Morgan Chase 1000 1/1/2018 12 1 Bank of America 1000 1/2/2018 13 2 Citigroup 5000 1/4/2018 14 3 Wells Fargo 82116 1/7/2018 15 1 Goldman Sachs 312 1/1/2018 16 2 Morgan Stanley 54894 1/2/2018 17 1 U.S Bancorp 16549 1/4/2018 <colgroup><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>

Formula from D11 to infinity is =SUMIFS(Details!$D:$D,Details!$C:$C,Received!$C11,Details!$E:$E,Received!D$10)

Formula for D9:_9 is =SUM(D11:D66)

Hope someone can help me.