We work in general according to some of the conditions to the data to be summed up, if we do not have a good formula for summation, only by our own hands to operate will be a lot of trouble, but also a great waste of our time, I explain how to quickly explain the data to the condition of the summation of data:

Steps/Methods

In their own need to sum up the form to click

Use the formula "= sumif ()"

In the formula in parentheses, in turn, click on the "name of a line" "Zhang San "" income "in the middle because the comma separates the specific look at the picture in the operation

Two. Batch processing data

We will encounter such a situation when organizing data or reports, is the need to merge the data in the same column, and then organized, but if the data is too large, then we will be these data one by one to organize us will be very time-consuming, a waste of energy, how do we go about it? Partners watch the editor's steps:

Steps/Methods

Using the formula: (= A2 & "Specialty is:" & B2) detailed look at the following chart

& play a role in connecting the role of the

Three. Summation summary

We need to sum all the data in the sum of the time, but the data is too large, then we operate more trouble, I will teach you to use a method that can be quickly summed up the data, greatly saving us time, the method is as follows:

Steps/Methods

Select all the data, and then hold down the shortcut key "alt" + "="