{=$A$4:$A$11*C5:J5} PleaseHelpW/ArrayFormula

G

Gcook888

I have A B C D E F G H I J
M CorrectAns
4: 1
1 1
5: 1 1 .707 0 -.707 -1 -.707 0 .707
1 .707
6: 0
0 0
7: 0
0 0
8: 0
0 0
9: 0
0 0
10: 0
0 0
11: 0
0 0

Column M has the answer I get w/Array Formula : {=$A$4:$A$11*C5:J5} pasted in
M4:M11
The answer I am looking for is
{1*1;1*.707;0*0;0*(-.707);0*(-1);0*(-.707);0*0;0*.707}

I have seen an example where the 1-d arrays are both vertical that is supposed
to work. I suspect somehow my answer is just the range $A$4:$A$11 !

Please Help me and I'll pray for you.
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

{=$A$4:$A$11*C5:J5} I am so stuck. 1
{=$A$4:$A$11*C5:J5} Pls Help w/ Basic Array Formula 3
Windows 7 Duplicate files. 1
Problem locking a transaction record 5
If condition to find Target 2
Lookup, index, match, range, oh my... 1
Transpose data from columns to rows 3
Help with a cashflow table 2

Top