WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to add rows in excel with easy formula

July 21, 2022

You need to know the total value of a certain row or a number of rows while dealing with a huge dataset in Excel. There are several ways to accomplish it in Excel. This post will walk you through four quick and easy ways to add rows in Excel using formulae.

Using simple mathematical addition to add rows in excel with formula online, 2016 and 2019

1. Choose the cell where you wish to display the outcome.

2. Simply keep adding the desired cell references in the cell, followed by the addition (+) symbol.

3. The values in those cells will be added, and the outcome will be shown in the cell you choose.

Using the SUM function to add rows in excel

The SUM function may be used to calculate the total of your data.

1. Simply enter =SUM() in the field where you want to see the outcome.

2. Simply choose the cell you wish to examine inside the bracket and use the Fill Handle to move it through the other rows of the table.

3. To get the outcome, you may alternatively use the mathematical addition formula above inside these brackets.

Your results will appear in the cell that you picked once you have finished dragging the cells.

Sum of non-consecutive rows (rows that are not next to each other)

If the rows you wish to verify are not adjacent to one another, what will you do? For that,

1. Simply enter =SUM() in the field where you want to see the outcome.

2. Simply choose the cells manually inside the bracket, or type the reference number of the cell, followed by a comma (,).

You will receive the results once you have finished picking the cells.

Summation of rows with condition to add rows in excel with formula

What if an issue occurs when you need to present the result based on a certain set of criteria? Be not scared! Do you still recall all the logical constructions you studied in first grade? Just make use of that!

For clarification, see the image below.

1. In the cell, type the conditional formula =SUMIF().

2. After choosing the rows, place the condition and comma (,) sign inside the brackets (for example, we wanted to know the total of the marks over 80). All we had to do was choose all the rows under the Marks column name, separate them with a comma (,), and then type the condition within the quotation marks (e.g., =SUMIF(C4:C8,>80)).

It displays the precise outcome that we desired.

Note: This was an attempt to show you how to add rows in excel with formula in both windows and mac. 

To get the newest version of WPS Office, you must first access this operating interface.

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.