When we are working, we usually sum the data according to some conditions. Without a good summation formula, it will be very troublesome to operate it by ourselves, and it will also waste our time greatly. Bian Xiao will explain to you today how to quickly summarize the data:

Steps/methods

Click the table to sum.

Use the formula "=sumif ()"

In the brackets of the formula, click "Name Line", "Zhang San" and "Income" in turn, because there is a comma between them. See figure for operation.

Two. Batch processing of data

When sorting out data or reports, we will encounter such a situation, that is, we need to merge the data in the same column before sorting out. But if the amount of data is too large, we will spend a lot of time and energy to sort out these data one by one. What do we do? Little friends are optimistic about Bian Xiao's operation steps:

Steps/methods

Use the formula: (= A2 & amp； "Specialty is"&; B2) Look at the pictures below carefully.

& It plays the role of connection.

Three. Summarize and generalize

When summing, we need to add up all the data, but if the data is too large, we will be more troublesome to operate. Bian Xiao will teach you to use a method that can quickly summarize data and save us a lot of time. The method is as follows:

Steps/methods

Select all data, and then press and hold the shortcut "alt"+"=".