Forum Discussion
Solved
Sum by month
Hello, I am having difficulty summing the table by months. please see attached. thank you
=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.
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?
=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.
- wow. That worked. thank you very much!