How Excel uses dynamic formulas

Source: Internet
Author: User

I. Construction of dynamic formulas

In an Excel worksheet, you can design a dynamic formula if you view the statistical results of a dynamic region at any time:

Enter a function in a cell: =average (INDIRECT at the start of the data statistics area): INDIRECT (end position mark of the data statistics area))

For example:: =average (INDIRECT (A1): INDIRECT (B1))

This shows that the a1:b1 of these two cells represents the range of data statistics, not the actual range of data to be counted.

Next, how do you use a dynamic formula?

Ii. Use of dynamic formulas

If you need to count the values in the B2 to H51 area (and you can do other calculations)

As long as you enter D2 and H51 separately in the A1 and B1 cells, the corresponding mean values are displayed in the cell in which the function is located.

This is the specific use of dynamic formulas.

As we all see, the range to be counted is the mean value of the D2 and H51, but in practical applications we just need to enter D2 and H51 separately in the A1 and B1 cells to determine a cell address name.

The above method, I hope you can do it once, you will understand the mystery of it!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.