Скачать или смотреть Excel Subtotal 9 vs 109 - Excel Tips and Tricks

Discover the difference between subtotal 9 vs 109. I will also explain what does subtotal 109 mean in Excel, and what is the difference between 9 and 109 in Excel subtotal function?

Excel Subtotal is a feature in Microsoft Excel that allows users to group and summarize data in a table or range. Subtotal 9 and Subtotal 109 are two different functions available in Excel Subtotal. Subtotal 9 calculates the sum of values in a column or range, whereas Subtotal 109 calculates the average of values. Depending on the type of data you are working with, you may find one function more useful than the other. It is important to choose the correct function to ensure accurate results and make data analysis more efficient.

Use Function Number 9
to calculate subtotal for
filtered dataset
Do not use it on hidden row.


Use Function Number 109 to Calculate
Subtotal for
Filter dataset
Hidden row(s) dataset

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ