Software Tutorial
Office Software
How to count the number of participants in various regional branches in Excel table_How to count the number of participants in various regional branches in Excel table
How to count the number of participants in various regional branches in Excel table_How to count the number of participants in various regional branches in Excel table
The company holds a general meeting, and branches from all over the country actively participate. It is necessary to count and collect the number of participants in each regional branch. However, the data in the Excel table is complicated. How to efficiently count the number of participants in each regional branch? PHP editor Banana today brought the method of counting the number of participants in various regional branches using Excel table data. Let’s take a look at the specific operation with the editor!
1. Create a new Excel document, open it and add test data in the table, as shown in the figure.
2. After adding 10,000 test data, enter the calculation formula =SUM((LEFT($D$6:$D$13,2)="Guangdong")* in cell H5 $E$6:$E$13), left means intercepting the string starting from the left, and sum means summing. The formula means that when the two texts intercepted starting from the left are equal to the value in the condition, the data will be summed.
3. After completing the formula input, press the shortcut key to obtain the calculation result. If you use the enter key here, you will not be able to obtain the calculation result. The details are as follows.
4. Therefore, you need to use the shortcut key shift ctrl enter to obtain the result. The result is as shown in the figure.
5. When counting participants from branches in other two provinces, we only need to copy the formula in cell H5 and change [Guangdong] in the condition to [Anhui] , [Sichuan], just use the shortcut key shift ctrl enter to get the calculation results.
The above is the detailed content of How to count the number of participants in various regional branches in Excel table_How to count the number of participants in various regional branches in Excel table. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
how to add page numbers in word
Aug 05, 2025 am 05:51 AM
To add page numbers, you need to master several key operations: First, select the page number position and style through the "Insert" menu. If you start from a certain page, you need to insert the "section break" and cancel the "link to the previous section"; second, set the "Home page different" to hide the home page number, check this option in the "Design" tab and manually delete the home page number; third, modify the page number format such as Roman numerals or Arabic numerals, and select and set the starting page number in the "Page Number Format" after sectioning.
How to add transitions between slides in a PPT?
Aug 11, 2025 pm 03:31 PM
Open the "Switch" tab in PowerPoint to access all switching effects; 2. Select switching effects such as fade in, push, erase, etc. from the library and click Apply to the current slide; 3. You can choose to keep the effect only or click "All Apps" to unify all slides; 4. Adjust the direction through "Effect Options", set the speed of "Duration", and add sound effects to fine control; 5. Click "Preview" to view the actual effect; it is recommended to keep the switching effect concise and consistent, avoid distraction, and ensure that it enhances rather than weakens information communication, and ultimately achieve a smooth transition between slides.
Complete guide to collaborate in Word and Real Time Co -authorship
Aug 17, 2025 am 01:24 AM
Microsoft Word CollolaBate: How to work with co -authors in Word, edit in real time and manage versions easily.
How to customize the tapes in Office step by step
Aug 22, 2025 am 06:00 AM
Learn to customize the tapes in Office: Change names, hide chips and create your own commands.
How AI Will Give Superpowers To ERP Solutions
Aug 29, 2025 am 07:27 AM
Artificial intelligence holds the key to transforming ERP (Enterprise Resource Planning) systems into next-generation powerhouses—equipping organizations with what can only be described as digital superpowers. This shift isn't just a minor upgrade; i
How to use free Word: all the advantages of the Office online version
Aug 14, 2025 pm 02:30 PM
Do you want to use free Word? Discover here all the advantages that the Microsoft Office online version can offer you for your team.
Get a list of unique values in Excel & extract unique rows
Aug 18, 2025 am 07:39 AM
This is the concluding segment of the Excel Unique Values series, detailing how to retrieve distinct or unique values from a column using formulas, along with customization tips for various data types. You'll also discover how to swiftly generate a d
How to create a table with a repeating header row in Word
Aug 08, 2025 am 04:41 AM
Ensurethefirstrowofyourtablecontainscolumnheaderslike"Name"or"Date"andmaintainspropertablestructurewithoutmergedcells.2.Clickanywhereinthefirstroworselectitentirelybyclickingitsleftedge.3.GototheTableDesigntab(Windows)orTabletab(M
