Looping to add values based on +/- that correspond to a date

[B-radK]

Hello team.

I have a range that has a date column and a value column. Next to the dates, there are values with either a positive or a negative value.

The range in columns A to D can be dynamic, i.e. the total number of rows can differ from month to month.

The columns will not change position, they will stay the same.

I would like to loop through the range and sum the numbers with positive values for a specific date and paste them in the corresponding date row, under the positive column.

Similarly, I would like to loop through the range and sum the numbers with negative values for a specific date and paste them in the corresponding date row, under the negative column.

Please see the before and after shots below of what I would like to achieve.

I'm still in the throws of a VBA course and I know how to loop through ranges and select data I need. However, what is outlined above and what I would like to achieve, is well beyond me at this stage.

Any help would be greatly appreciated.

Thanks
Brad.

 

[Fluff]

You can do this with a formula, no VBA needed.
In H2 copied down
=Sumifs(D:D,D:D,">0",C:C,G1)
and in I2 copied down
=Sumifs(D:D,D:D,"<0",C:C,G1)

 

[B-radK]

Thanks Fluff.

That's annoying. I've been toying with trying to loop for well over a week now. I have sumifs and sumif on my monthly budget spreadsheet, summing based on criteria, such as "supermarket", "entertainment", "alcohol", etc. ...The same spreadsheet I've been running for about 3 years now.

Once again, thanks Fluff, you're always on point.

I'm off to get a scotch... ?

 

[Fluff]

You're welcome & thanks for the feedback.