• ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
Excel

4 Ways to Sum Horizontally in Excel

0 Comments

4 Ways to Sum Horizontally in Excel: Summing horizontally is considered the most basic and commonly used operation in Excel. However, not everyone pays attention to how many ways there are to calculate and which method is the fastest and most accurate for each calculation, worksheet. Please follow the following article to understand the ways to sum horizontally in Excel.

1. Use the + sign to sum horizontally

For example, we have a data table as shown below. To sum horizontally, use the + sign with the following formula:
=C2+D2+E2

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

Copying the formula for the cells below will give us the result:

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

2. Use the SUM function to sum horizontally

Function syntax: =SUM(number1,[number2],…)
Where:

  • number1: Required argument, is the first number you want to add. That number can be 4, reference a cell like B6, or a range of cells like B2:B8.
  • number2-255: Optional argument, is the second to 255th number you want to add. That number can be 4, reference a cell like B6, or a range of cells like B2:B8.

Applying the function structure above, we have the formula for summing horizontally as follows:

=SUM(C2:E2)

Copying the formula for all cells in the column will give us the result:

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

Or you can also use the SUM formula as follows to sum:

=SUM(C2;D2;E2)

Copying the formula for all cells will give us the result:

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

3. Use shortcut keys to quickly sum horizontally

In addition to the above 2 ways of entering formulas, we can use shortcut keys to quickly sum horizontally by placing the mouse cursor where we want to sum and then pressing the Alt + = shortcut key. Just like that, the SUM function will be applied to that cell to sum horizontally.

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

If you want to sum multiple rows at once, just highlight those cells and press Alt + =. The result is that the SUM function will be applied to all the highlighted cells.

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

4. Sum horizontally with AutoSum

Just place the mouse cursor where you want to sum and select the Home => AutoSum tab. Just like that, the Sum formula will be applied to quickly sum horizontally. If you want to sum multiple cells at once, just highlight those cells and select AutoSum.

4 Ways to Sum Horizontally in Excel

4 Ways to Sum Horizontally in Excel

Thus, the above article has instructed you on how to sum horizontally in Excel. Hopefully, the article will be useful for you in your work. Wish you success!

Rate this post
43
312 Views
How to remove the green Smart tag arrow in Excel cellsPrevHow to remove the green Smart tag arrow in Excel cellsMarch 22, 2023
How to calculate working days, days off, and working days in ExcelMarch 22, 2023How to calculate working days, days off, and working days 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
  • 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
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • 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
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
Products
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Microsoft Visio Standard 2016 Key 1PC Microsoft Visio Standard 2016 Key 1PC $9.00
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
  • Windows Server 2008 R2 Standard Windows Server 2008 R2 Standard $10.00
  • Project Professional 2024 Project Professional 2024 $33.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Buy Windows Server 2016 Essentials Key Global Buy Windows Server 2016 Essentials Key Global
    Rated 4.75 out of 5
    $10.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.