How to put data from one column into different columns

[bakroi]

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)

Question_months.ods

[PYS]

Hi

You can use SUMPRODUCT for example. See Question_months.ods

[EDIT]

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

=SUMPRODUCT($data.$B$5:$B$11;$data.$C$5:$C$11=OFFSET($data.$I$3;COLUMN(A1);0))

Regards

[bakroi]

Thank you very much!,
I got it!