Page 257 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

For calculating the total for all the students, select the field where you want to store them, now select the range,
and insert the formula. Array formulas are available in every version of Excel, so you don’t worry about your excel
version. There are hundreds of operations possible using array formulas, which we will discuss in this article later.
But before proceeding let’s understand what is the need to use an array formula.
Why use an Array Formula?
Array formulas are to most powerful yet most easy-to-use calculation tools which could be used to perform
complex calculations and take place of hundreds of formulas with a single formula. You can further specify
conditions for the calculation of data. Not just calculations you can also count the chars in cells, add date, day, or
time, and even pick random data.
How to insert an Array Formula?
Before entering the Array formula fir of all we understand some important points about the Array formula:
• After typing the formula you have to press keys CTRL+SHIFT+ENTER together. It will automatically change
the normal formula into an array formula.
• If you manually type braces around the formula then it will not convert the formula into an array formula. You
have to use CTRL+SHIFT+ENTER keys to convert the formula into an array formula.

• Whenever you edit the array formula the braces will disappear automatically and you have to again press the
combination of CTRL+SHIFT+ENTER keys.
• If you forget to press the CTRL+SHIFT+ENTER keys then your formula will work as the normal formula.

Now let’s understand inserting an array formula.
Single Cell Array formula
Every array formula returns the result in either single or in multiple cells. So when an array formula returns its result
in the single-cell then such type of formula is known as a single-cell array formula. Such types of formulas are
SUM, AVERAGE, AGGREGATE, MAX, MIN, etc. Follow the following steps to use the single-cell array formula:
Step 1: Select the cell where you want to store the answer.
Step 2: Now go to the formula bar and write an “=” sign.

Step 3: Now to formulas (highlighted below), and select the operation you want to perform.

Single-cell-array

Step 4: Here we want to perform the sum operation. Click on sum and a new popup will open. Write the cells you
want to perform the operation with.

244

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77