# How to get "automatic" matrix functions?

Hi there,

I'm talking about autocompletion of functions in calc.

Step 1:

One example: Assume you like to add A1:A100 in B1, A2:A100 in B2 etc. To accomplisch that, you enter "=SUM(A1:A$100)" in B1. Afterwards, you "drag" the formula to B2 … B100 and everything will be fine.

Step 2:

But I'm using a matrix sum function as documented in http://

You don't enter the "{}" by hand, but you enter the rest and finish the command with CTRL+SHIFT+RETURN _or_ you go into the function editor and check "matrix" (you find it at the lower left).

The problem ist: I'm unable to "drag" the matrix function of Step 2 like described in Step 1.

What I've tried:

* Enter the matrix function and drag it. – Does not work.

* Enter the function without "{}" and drag it (works). But afterwards I'm unable to mark all those functions as matrix fanctions at once. I need to mark them seperately one-after-another.

So the question ist: How to "drag" a matrix function with the same behavior as "normal" functions (as described in Step 1)?

I hope you can understand my description.

Thank you for your help!

## Question information

- Language:
- English Edit question

- Status:
- Solved

- Assignee:
- No assignee Edit question

- Solved by:
- Tony Pursell

- Solved:

- Last query:

- Last reply: