Google Sheets – SUMIF by Month from Different Entry Locations

formulasgoogle sheetsgoogle-sheets-arrayformula

Beforehand please check my sample sheet.

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 had any luck.

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

Best Answer

S2:

=ARRAYFORMULA(SUMIF(TEXT($F$2:$P$5,"mmmmyyyy"),S$1&"2018",$E$2:$O$5))

Drag to right.

SUM E2:O5,IF F2:P5 has S1's Month&2018.