Contents

# Entering Matrix Formulas

The following is an example of how you can enter a matrix formula, without going into the details of matrix functions.

Assume you have entered 10 numbers in Columns A and B (A1:A10 and B1:B10), and would like to calculate the sum of each row in Column C.

1. Using the mouse, select the range C1:C10, in which the results are to be displayed.

2. F2 दबाएँ या सूत्र पट्टी में इनपुट लाइन पर क्लिक करें.

3. बराबर चिह्न (=) प्रविष्ट करें.

4. दायरा A1:A10 चुनें, जो योग सूत्र के प्रथम मूल्यों को रखता है.

5. न्यूमेरिकल कुंजीपट में (+) कुंजी दबाएँ

6. द्वितीय स्तम्भ के कक्षों B1:B10 में से संख्या चुनें.

7. End the input with the matrix key combination: Shift+Command Ctrl+Enter.

The matrix area is automatically protected against modifications, such as deleting rows or columns. It is, however, possible to edit any formatting, such as the cell background.

Related Topics

Calculating With Formulas

Please support us!