How do Excel tables enter sum formulas in batches?

Usually in the Excel table use process, if you use the sum more than once, you will not struggle to enter the sum formula again and again? In fact, do not do this, the following small series to teach you how to bulk input Excel table formula, fast and convenient oh.

How do Excel tables enter sum formulas in batches?

As in the following table, you need to set the sum formula in the yellow cell.

To set the method:

Select the area that includes the yellow row, and press ALT and = (press ALT key and then equal sign) to complete the sum formula input.

What if there are multiple subtotal lines that need to be set?

To set the method:

1, select the entire data area (including yellow area)-ctrl+g Open the positioning window

2. Selecting blank values in the Positioning window selects the blank rows and columns where you want to set the formula. Then press ALT and the = number to complete the fill.

After filling

What do you mean, you saved a lot of time?