one column one row Cross Multiply

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have one column of numbers across and 1 row of numbers down. How do
I cross multiply so that I can then somehow copy this across 100 cells
and down 10 rows without having to enter the formula in each cell ? I
am getting alternate zeros when I try copying and pasting down OR up.
Thanks Rick
EG:
0.1 0.2 0.3 0.4

25.125 2.5125 0.5025 0.15075 0.0603
25.5 0 0 0 0
26.635 66.9204375 33.62751984 5.069348616 0.305681722
28.62 0 0 0 0

Where the original 2.5125 is =SUM(A3*B1) then I copy it....I can see
what it is doing....I just can't find the format to do this correctly
 
Jason has given you your answer, but just to try and help clarify - A reference
such as A1 consists of both a column and a row reference. Each of these can be
jointly/severally preceded by a $ sign which will *Fix* that part of the
reference, eg A1, $A1, A$1, $A$1.

=A1 entered in B1 and copied down will become:-

=A2
=A3
=A4 etc

But if you fixed the row part with =A$1 and then did all that, it would remain
=A$1 all the way down.

Likewise =A1 entered in A2 and copied across will become

=B1
=C1
=D1, whereas =$A1 will remain as is.

Various combinations of these are then used to accommodate things such as what
you are trying to do.
 
I like to use Range Names. For example, give your top row a name like
"Top." Give your Column data a name like "Side." All the cells in your
table would have the same formula..."=Top*Side" Excel will take care of the
correct cell reference. I find this easier to read also. HTH. :>)
 
Back
Top