Sum by month

[Tony2021]

Hello, 

I am having difficulty summing the table by months. 

please see attached. 

thank you

[#2]

@Tony2021 

=SUMPRODUCT((MONTH($B$2:$I$2)=MONTH(B1))*$B$3:$I$3)

Maybe with this formula. 

[#3]

@OliverScheurich 

nice. that works. 

I do have a follow up if you dont mindthough. In my example, I provided the amounts in the rows however in my actual database, the amounts are in 1 column.  I tested it and it seems as though that if in the amounts are in columns then what it returns is some much higher number.

I have attached an updated spreadsheet.
Do you have a solution for when the amounts are in columns?

[#4 · Accepted solution]

@Tony2021 

=SUMPRODUCT((MONTH($B$2:$J$2)=MONTH(B$1))*TRANSPOSE($B$10:$B$18))

Maybe with this formula. Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021. 

[#5]

wow. That worked. thank you very much!