Looking for some sort of transpose...

To answer point 3 first, put this array* formula in H2:

=INDEX($B$2:$B$3330,MATCH(1,($A$2:$A$3330=ROWS($1:1))*($E$2:$E$3330=COLUMNS($H:H)),0))

*Note that an array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual |Enter|.

Then you can copy that formula into I2:J2, and then you can copy the formulae from H2:J2 down as far as you need to (to row 295 in your example file - beyond that you will get errors, as you will have run out of data).

Hope this helps.

Pete

Hi
See my proposed solution EXCel help(1).xls

Hey, Dave,

congrats on exactly 2,500 posts.

Pete

Unless I'm missing something, you have two questions. The first question is one of the most basic problems to solve in excel and less a problem as using the basic functionality of Excel. So if my solution solves your problem, please spend a few minutes on YouTube looking at Excel Tutorials. The second problem is a bit more interesting and along the lines of many of the posts I've seen in this forum.

First Problem, as I understand it:
Note: C2: C13 is a 12x1 vector/matrix, where rows/columns are defined: ROWSxCOLUMNS
...so a 12x1 vector/matrix transposes to a 1x12 vector/matrix
...so if you transpose C2:C13 to another range, where C2 is located at O1, it will occupy: cells: O1: Z1, not Z12 ( so I'll assume Z12 is a typo moving forward)

That said, how I understand your problem should be a simple solution.

Second Problem, as I understand it:
Step 1: write =C2 in O1
Step 2: write =C3 in P1
Step 3: highlight O1 and P1 by left clicking (once) with your mouse on O1 and drag your curser to P1 before you release the "left click" on your mouse
Step 4: hover your mouse over the bottom right corner of the selected range until you see a small plus sign (with black interior)
Step 5: drag the highlighted region to Cell Z1 by left clicking as soon as step 4 is completed and drag the mouse straight to the right until region O1 to Z1 is highlighted.

Now the summations are a more interesting problem to solve. First note:
Note: the following solution ignores conditions:
Then in H2, write formula: =sum(B1:B12)
Then in I2, write formula: =sum(B1:B12)
Then in J2, write formula: =sum(B1:B12)

Then Note: the sumif(...) function has three arguments, let's call them A, B, and C such that the formula is written: =sumif(A,B,C)
A: range of conditions
B: criteria
C: range to sum

Thus, your H2, I2, and J2 formulas would be:
H2: =sumif(E1:E12,1,B1:B12)
I2: =sumif(E1:E12,2, B1:B12)
J2: =sumif(E1:E12,3, B1:B12)

I apologize if I'm wrong about what I understand to be your first problem because I see you've got a fair amount of posts so I'll assume that you spent a lot of time working with excel. In any case, I hope what I said about the first part of this post isn't discouraging. Thank you for your contribution because I'm sure others have the same question. I certainly learned something when I helped with the second part!

Let me know if there are any other questions or if I can help further.

Cheers!

PS Wow! Soooo many posts came before mine by the time I was through! That's why this forum rocks

Hi

Thanks for the help.

There is one problem. When i drag the formula from o2 to ad2 there comes values also to aa2,ab2,ac2 and ad2. There should not be any values because there should only be values from the c column if there is number one in a column. I put with red color the values which should not be there. I also added few comments to make myself more clear.

Hi
See the file EXCel help(3).xls

1st.) in H2 and válid to H2:Jnn (CSE array formula) (post 7)

Formula:

Please Login or Register  to view this content.

2nd.) In O2 and valid to O2:Znn (post 7)

Formula:

Please Login or Register  to view this content.

3th.) In AG2 and valid to AG2:ARnn sanme as 2nd. but column D

Formula:

Please Login or Register  to view this content.

Regards

Thank you for everybody. It works now.