How a Word table can be evaluated in two dimensions

In the process of writing a report in Word, a few simple data summary tables are often involved in the document. Although the table rollup is Excel's strength, but if for a simple summary to use Ecxel, and Ecxel still need to constructor formula, also need to import export or consider data format problems, in fact, it is not convenient. In fact, by using the SUM function directly in a Word table, you can use left, right, ABOVE, below, and so on to make a single row subtotal, and mix these parameters to compute the sum of data for two dimensions.

The following table, for example, if you want to summarize the "John" 3-day data, simply start the formula box with the Formula button under the Layout tab in its cumulative cell, and enter "=sum" to determine the sum of the left data.

However, if in the cumulative cell such as Dick, not only do you want to calculate the sum of the data of the current person's left cell, but also add the above data, what to do? In fact, only when you calculate the cumulative of subsequent cells, you change the parameters in the formula to left and above, which means that the left-hand side and the top are calculated together.

In addition, the combined usage of the four parameters mentioned above also has several conditions.

Top and bottom of cell

=sum (Above,below)

Cell left and right

=sum (Left,right)

Cell Right and top

=sum (Right,above)

Cell left and bottom

=sum (Left,below)

Right and bottom of cell

=sum (Right,below)

The above usages of these 4 parameters in

Word are not only unique to the SUM function, they also apply to common functions such as average, COUNT, MAX, MIN, product, and so on.