Drag formulas

Occasional Visitor

Hi, I am trying to develop a cheat sheet for multiplications for estimating.  Usually if you have a vertical column with numbers and a horizontal row with numbers you can drag the formula across or down with one answer.  Not happening on my spreadsheet

2 Replies

@mnorman250 

If you have access to dynamic arrays you might try:

[A2:A11 = 1 to 10  B1:K1 = 1 to 10]

 

=A2:A11*B1:K1

 

Another approach:

 

=MMULT(A2:A11,B1:K1)

 

 

A screenshot of the error might help to give the perfect answer.