Cumulative Sum based on two criteria

[hinklewj]

Hi - In sheet1 I have a list of accounts in column A and a list of dates in row 4 with corresponding data below. In sheet2 I have the same list of accounts in column A and the same dates in row 4. But the data below I want to be a formula showing the cumulative totals in each month. I've tried various formulas but am under the gun and having issues..

 

[hinklewj]

Btw the names on each sheet might not line up exactly, thus I'm looking for a dynamic formula.

 

[hinklewj]

Maybe this is more clear? In sheet1 I have a list of accounts in column A and a list of dates in row 1 with corresponding data below. In sheet2 I have the same list of accounts in column A but in a different order and the same dates in row 1. But the data below the dates on sheet2 I want to be a formula showing the cumulative totals in each month from sheet1. I've tried various formulas and am still having issues.