SOLVED

# Sum by month

Super Contributor

# Sum by month

Hello,

I am having difficulty summing the table by months.

thank you

4 Replies

# Re: Sum by month

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

Maybe with this formula.

# Re: Sum by month

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?

best response confirmed by Tony2021 (Super Contributor)
Solution

# Re: Sum by month

``=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.

# Re: Sum by month

wow. That worked. thank you very much!