Ask Your Question
0

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)

C:\fakepath\Question_months.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

pierre-yves samyn gravatar image

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

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

edit flag offensive delete link more

Comments

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

Stats

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

Seen: 29 times

Last updated: Oct 11 '16