Ask Your Question

How to put data from one colum into different colums

asked 2016-10-11 13:58:55 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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)


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-10-11 14:51:58 +0100

pierre-yves samyn gravatar image

updated 2016-10-11 14:57:30 +0100


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:



edit flag offensive delete link more


Thank you very much!, I got it!

bakroi gravatar imagebakroi ( 2016-10-11 15:59:36 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-11 13:58:55 +0100

Seen: 29 times

Last updated: Oct 11 '16