Autofillable Formula to transpose sum of row data into a columns

Is there an excel formula that sums quarterly row data and transposes it into a column data? Being able to autofill right would be a plus. Thanks

Please see the attached

1 answer

  • answered 2018-07-11 03:24 J.Doe

    What about something like this: enter image description here

    =SUMPRODUCT((ROUNDUP(MONTH($A$2:$A$13)/3,0)=VALUE(RIGHT(F1,1)))*$B$2:$B$13)

    EDIT:

    Sorry I didn't notice your cut off period was offset, try:

    enter image description here

    =SUMPRODUCT((ROUNDUP((MOD(MONTH($A$2:$A$13)+1,12)+1)/3,0)=VALUE(RIGHT(F1,1)))*$B$2:$B$13)