• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

A very simple example of an array formula in Excel

0 Comments

The array formula in Excel is a powerful tool for users to solve difficult problems. A simple array formula can represent multiple calculations at once and thus replace many commonly used formulas. It is strange that over 90% of users have never used array formulas in their spreadsheets because they are hesitant to start with an array formula. This article will introduce you to some extremely simple examples of array formulas in Excel. Please read on.

1. Extremely simple examples of array formulas in Excel

At the Excel interface, users need to have data tables like the one below. In this example, you need to calculate the total amount based on the unit price and quantity of some items.

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

Typically, users need to calculate the total amount according to the formula: =Unit price * Quantity. Then you use the SUM function to calculate them together and get the result as follows:

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

Instead of doing it the above way, you can use an array formula. To do this, you enter the formula: =SUM(C2:C5*D2:D5) and then press the Ctrl + Shift + Enter key combination. Then the result returns as follows:

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

With this method, you can perform calculations faster. Note that for an array formula, you need to use the Ctrl + Shift + Enter key co

mbination to end the formula. Because if the result is not returned, an error will be reported as shown below:

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

2. Example of an array formula for creating a constant

To create an array constant, you need to enter a list of items. In the example below, you need to select cell A1:D1. Then enter the list of Congratulations, You, Succeeded, and put them in curly braces. Then press the Ctrl + Shift + Enter key combination to use the array formula.
By observing the method and the result image below, you will understand more clearly.

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

3. Some other examples using array formulas

In addition to the SUM function example above, you can do the same with other functions such as LEFT, MID, RIGHT, MAX…

3.1. Array formula with LEFT, RIGHT, MID function

With these 3 functions, you can extract n characters from a string from the left, right or middle. You just need to enter the fo

rmula as usual and then press Ctrl + Shift + Enter. Then the result returns as follows:

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

3.2. Array formula with MAX function

In this example, you need to find the maximum value of A-B. Normally, you will find the A-B difference in the cells below and use the MAX function to find the maximum value. After completing the steps, the result returns as follows:

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

Instead of having to perform the above steps, you can use array formulas to make calculations faster. Enter the formula: =MAX(A2:A5-B2:B5) and then press the keyboard combination Ctrl + Shift + Enter. By looking at the image below, you will understand better how to do it:

A very simple example of an array formula in Excel

A very simple example of an array formula in Excel

The article above by Buffcom.net has introduced users to very simple examples of array formulas in Excel. Hopefully, this article will provide useful information for readers when working with Excel. Wish you success in your work!

Rate this post
41
306 Views
How to Create WordArt in Word 2013, 2016, 2019PrevHow to Create WordArt in Word 2013, 2016, 2019March 1, 2023
How to Print Even/Odd Pages in Word, Excel Version 2010, 2013, 2016March 1, 2023How to Print Even/Odd Pages in Word, Excel Version 2010, 2013, 2016Next

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year
    Rated 4.91 out of 5
    $34.00
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Project Standard 2021 Microsoft Project Standard 2021 - 1 PC $13.00
  • Windows Server 2019 Standard Key Global Windows Server 2019 Standard Key Global
    Rated 4.68 out of 5
    $7.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.