Introduction to epidemic prevention statistics table
The main content of the epidemic protection statistics table: name, gender, contact information, ID number, community, body temperature, any abnormalities, people in contact today, person in charge, notes and other related information. Huajun Software Park provides downloads of high-quality Excel templates and epidemic prevention statistical table excel templates. You can download the source files for you to edit, modify and replace. The epidemic prevention statistical table template can be found in Huajun Software Park.
General Tips for Epidemic Protection Statistics Table
1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
it works
it works
it works