sum all months of the year

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    sum all months of the year

    Hello Dears,

    I have this assignment with 4 factors & 60 Months of the next 5 years

    I want to fill the below table to summarize the whole original table by summing all months together in each year

    ( I used =sumproduct with * , but still I had to choose each 12 columns Manually)

    WHAT IS THE BEST APPROACH FOR THIS

  • alansidman

    Added the Label Cross Post

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!