• 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

How to use CONSOLIDATE to summarize and merge data in Excel

0 Comments

CONSOLIDATE is one of the most effective tools for summarizing and merging data in Excel. It helps to calculate more efficiently by allowing for quick calculations such as sum, average, max, min, etc. within a worksheet. In this article, we will show you how to use CONSOLIDATE to summarize and merge data in Excel.

How to use CONSOLIDATE

For example, suppose we have a data table as shown below. To summarize the data using the Consolidate tool, first place the mouse pointer where you want to create the new summary report. Next, select the Data tab on the ribbon, and then click Consolidate under Data Tools.

How to use CONSOLIDATE to summarize and merge data inA Consolidate dialog box appears. Under the Function section, select the calculation function you want to perform such as Sum, Count, Average, Max, Min, etc.

How to use CONSOLIDATE to summarize and merge data inNext, under the Reference section, enter the location of the data range by clicking the Reference box and selecting the data range with the mouse. In this case, we will enter a reference to the data table. After scanning the Reference range, click the Add button to add the reference address to All References.

How to use CONSOLIDATE to summarize and merge data inNext, select the row or column headings:

  • Top row: If the first row is a header, select this checkbox.
  • Left column: If the first column on the left side of the data range is a header, select this checkbox.

How to use CONSOLIDATE to summarize and merge data inAfter setting up the Consolidate table information, click OK for Excel to create the summary report. The result will be a summary table using the SUM function as selected quickly as shown in the image below.

How to use CONSOLIDATE to summarize and merge data inThus, this article has provided you with the steps to use CONSOLIDATE to summarize and merge data in Excel. We hope this article will be helpful to you in your work. Good luck!

Rate this post
37
280 Views
How to run Control Panel as an Admin on WindowsPrevHow to run Control Panel as an Admin on WindowsMarch 3, 2023
How to freeze a row or multiple rows in ExcelMarch 3, 2023How to freeze a row or multiple rows in ExcelNext

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
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
Products
  • Windows 10 Home OEM Key Global Windows 10 Home OEM Key Global
    Rated 4.80 out of 5
    $6.00
  • Microsoft Visual Studio 2019 Professional Key Microsoft Visual Studio 2019 Professional Key
    Rated 4.84 out of 5
    $15.00
  • Microsoft Project 2019 professional Key Global Bind to your Microsoft Account Microsoft Project 2019 professional Key Global Bind to your Microsoft Account
    Rated 4.93 out of 5
    $12.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.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
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.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
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.