Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Feb 15, 2022
Solved

Sum by month

Hello,    I am having difficulty summing the table by months.  please see attached.  thank you      
excel
  • OliverScheurich's avatar
    OliverScheurich
    Feb 15, 2022

    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. 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 15, 2022

Tony2021 

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

Maybe with this formula. 

Resources