Shulou(Shulou.com)11/24 Report--

A few days ago, my colleague asked me for help:

Collect all the data and 12 tables at the end of each year!

It is too difficult for me to merge cells and copy and paste them repeatedly every time.

Is there a more convenient way?

Of course there is!

Doesn't Excel exist to facilitate the calculation of data?

How to quickly sum all the data in a worksheet?

To put it simply, it is quick summation, so what is "fast" summation?

Use "=" to add cells one by one? Or is it a functional formula?

None of this is fast enough.

A shortcut key, you can quickly achieve the sum of data summary!

To select all forms, press [Alt + =].

The moving picture is shown as follows:

02 there is a space sum [Alt + =], but it is OK.

However, there are spaces in the cells, or the data that needs to be summarized is interspersed in the worksheet.

At this point, just follow one method, and this will happen:

The subtotal line is not worth it.

How to solve this?

Don't worry.

This occurs because [Alt + =] is a shortcut for the "= SUM" formula.

It can only quickly find a column or a row of data.

So, we just need to find all the spaces before that.

Then enter this function in the space to find the value of this row or column.

So, how do you find all the spaces?

Let's demonstrate it again:

❶ press the [Ctrl + G] positioning shortcut, select [positioning condition] in the pop-up window, select [null], and [enter]!

This finds all the spaces in the table.

❷ press the summation shortcut: [Alt + =].

All the spaces that need to be summed have numerical values.

The moving picture is shown as follows:

It is possible to summarize the data of a year's worksheet in a worksheet. How about a lot of tables and data?

For example, it always gives us a big head when we have to summarize the data for a whole year!

Don't be afraid, it's easy, too! One function can Hold N tabular data!

❶ selects the cells that need to be summed

❷ enter formula: "= SUM", select all worksheets

❸, click on the first cell and enter!

You can see that all the data aggregates have appeared!

The moving picture is shown as follows:

In fact, the summation of the data is not as difficult as you think.

It is important to remember that Excel is to facilitate data recording, not to bring you more questions.

After reading the article, have you learned it?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: dried Fish Editor: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.