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



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

    enter image description here