Skip to main content

Sum if by month different entry locations

Beforehand please check the following sheet here.

I'm trying to use SUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIF, FILTER, ARRAYFORMULA, but haven't gotten any luck.

Is there any way to do this or do I have to change the whole structure?

A. C.
  • 15
  • 5