How to put data from one column into different columns

It’s actualy a bit more complex.
I have in one page a colum with different values. Next to it a list with monthes (drop downlist). Is it possible to make a cel in another page under each month with the addition of the values corresponding to that month.

I’ve putted a simple version of the question in an attachement.

ps.: sorry about my poor Englisch, and thank you very much!!!

Bert (from Belgium)



You can use SUMPRODUCT for example. See Question_months.ods


To be able to copy the formula to the right you can use in Calcul.B6:



Thank you very much!,
I got it!