Current location - Training Enrollment Network - Mathematics courses - How to average the data filtered by conditions in Excel?
How to average the data filtered by conditions in Excel?
The specific operation steps are as follows:

If the data is in column A, enter:

= Subtotal (1, A:A)

Or = subtotal (10 1, A:A)

Formula expression: Calculate the average value of visible cells in column A, and the hidden data is not included in the calculation.

Microsoft Excel is one of the components of Microsoft office. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel is an important part of Microsoft office suite software, which can process all kinds of data, make statistical analysis and assist decision-making, and is widely used in management, statistical finance, finance and many other fields.

Microsoft OFFICE is the most popular office software, including two versions: OFFICE20 10 and OFFICE2007. Office 2000 is the representative product of the third generation office processing software, which can be used as a platform for office and management to improve users' work efficiency and decision-making ability. The Chinese version of Office 2000 has four different versions: standard version, small and medium-sized enterprise version, Chinese professional version and enterprise version.

In Office 2000, each component still has a clear division of labor: Generally speaking, Word is mainly used for text input, editing, typesetting, printing, etc. Excel is mainly used for heavy calculation tasks such as budget, finance and data summary. PowerPoint is mainly used to make presentations, slides and slides; Access is a desktop database system and database application; Outlook is a desktop information management application; FrontPage is mainly used to make and publish web pages on the Internet.

Microsoft Office XP is the most important version of Office ever released by Microsoft, and it is also considered as the most powerful and easy-to-use Office product so far. The new version of Office abandons the previous practice of naming products after their release year! XP in the product name is the abbreviation of English Experience, which means that the new version of Office will bring users a rich and fully expanded brand-new experience after including Web services covering a variety of devices.

In addition to the core Office XP programs (Microsoft Word, Excel, Outlook and PowerPoint), Office XP Professional Edition also includes Microsoft Access 2002, which is an Office XP database solution that can help users store, access and analyze data.