Wedding ceremony process scheduleHow to fill it out?
1. Before the wedding ceremony, the waiter assists the guests in distributing candies and cigarettes, and returns the excess to the couple in a timely manner.
2. Simen: Two waiters close the door of the wedding hall before the wedding ceremony begins and wait on both sides of the door. After the emcee's opening remarks, the door is slowly opened when the wedding march sounds, and the newlyweds enter;
3. Etiquette of exchanging tokens: During the ceremony of exchanging wedding tokens, a waiter will present the tokens on a tray with a red kerchief;
4. Wine-making ceremony: During the wine-making ceremony for the newlyweds, a waiter will present two glasses of wine on a tray covered with a red towel; while waiting aside, the newlyweds will take the empty wine glasses back after drinking the wine;
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: Multi-condition search
It is required to check that the department is production and the position is the name of the director.
The formula is:
=LOOKUP(1,0/((B2:B9=F2)*(C2:C9=G2)),A2:A9)
The writing method of multi-condition query of LOOKUP function is:
=LOOKUP(1,0/((condition area 1=condition 1)*(condition area 2=condition 2)),query area)
4: Calculate text equations
To calculate the text formula in the cell, first click on the first cell where you want to enter the formula and define the name:
Calculation = EVALUATE(C2)
Then enter the formula in the cell:
= CalculationRecommended by the editor of Huajun Software Park
Wedding ceremony process scheduleIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need to download the wedding ceremony process schedule, please download it quickly. also,Self-inspection declaration form for special and general equipment of administrative institutions,Self-inspection declaration form for land assets of administrative institutionsIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works