webnovel

How to sum the number of days and the number of days in the attendance sheet

2026-11-16 12:03
2026-11-16 13:04

If you want to count the number of days that meet specific conditions, you can use the Sumif function. For example, to count the number of days corresponding to Tuesday, the formula is =SUMIF($B$2:$AF$2,"AF$2",B3: AF3), and its grammar is =SUMIF(condition area, condition, sum area). To count the number of days from Monday to Friday, one way is to add up the five sumifs, which is equal to SUMIF.($B$2:$AF$2,"one",B3: AF3)+ SUMIF ($B$2:$AF$2,"two",B3: AF3)+SUMIF($B$2:$AF$2,"three",B3: AF3)+ SUMIF ($B$2:$AF$2,"four",B3: AF3)+SUMIF($B$2:$AF$2,"Five",B3: AF3); You can also use a constant array to simplify the formula. First, express Monday to Friday {"One","Two"," Three"," Four"," Five"}, and then use the formula =SUM(SUMIF($B$2:$AF$2,{" One"," Two"," Three"," Four"," Five"},B3: AF3)). If the attendance sheet used a tick to record attendance, the COUNTIF function could be used to calculate the number of days of attendance. The formula was "=COUNTIF(B3:H3,"")". The first function argument was to select the area to be calculated, and the second function argument was the symbol of the statistics (here, the attendance was recorded with a tick. Pay attention to the double quote in English). If you want to calculate the sum of the data within the specified date interval, you can use the function, which is in the format of the sumifs(sum region, condition region 1, condition 1,[condition region 2, condition 2],…). For example, to calculate the total number of customers between July 5th and July 11th (inclusive), the formula is =SUMIFS(C2:C19,A2:A19,">=2021/7/5",A2:A19,"<=2021/7/11"). If the cell is used to represent the date range, the formula is =SUMIFS(C2:C19,A2:A19,">="&A6, A2: A19,"<="&A12). Read more exciting novels for free

Latest Questions

Brocade clothes free listening to books online audio novels online listening

He could try listening to the audio novel "Royal Clothes" in the Book Listening Pavilion. There were many types of novels, and they were free. In addition, the audio novel of "Royal Guards" was broadcasted as An Ran's version, which could be downloaded through Baidu Cloud Disk (in MP3/M4A format), and the version with Bi Qingyun as the anchor could be purchased and listened to on relevant platforms. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-16 12:11

After the apocalypse, transmigration novels recommended the end of the female protagonist's novel

The following are some recommendations for female protagonists who have completed their apocalyptic transmigration: - [Return to the Beginning of the Apocalypse: The female protagonist returns to the beginning of the apocalypse after being betrayed by her lover. She uses her memories to open the ancestral space to survive and store goods.] - " The Doomsday Woman Traversing the Jianghu of the Republic of China ": published on Jinjiang Literature Network. The female protagonist traveled to the background of the doomsday of the Jianghu of the Republic of China to unfold the story. - [After the Apocalypse: The female protagonist transmigrated after living her entire life in the apocalypse.] - " Zombie Disaster: A Guide to Survival in the Ancient Future ": The female protagonist transmigrated into the daughter of a noble family. She thought it was a plot for a house fight. She did not expect to encounter zombies in the apocalypse, so she led the entire family to survive in the apocalypse. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-16 12:10

Can the apartment be built at will?

You can't just randomly hit the wall in the apartment. When carrying out indoor decoration activities in a residential building, it is forbidden to change the main body of the building and the bearing structure without the original design unit or the design unit with the corresponding qualification level proposing the design plan. The original design unit or the design unit with the corresponding qualification conditions should be entrusted to propose the design plan before the construction, otherwise it will be considered illegal demolition and modification. In areas like Nanjing, once the structure of the house needed to be demolished during the renovation process, a permit application must be made. The usual demolition of the wall between the bedroom and the balcony was banned. Beijing also prohibited any changes to the main body and bearing structure of residential buildings, such as changing the foundation, bearing walls, beams, roof, and other original design bearing components of the house, expanding the original size of the doors and windows on the bearing walls, and dismantling the walls connecting the house and the balcony. If the relevant regulations were violated, the person responsible for the safety of the house might not only face administrative punishment, but also be included in the social credit information management system. The removal of the bearing wall without permission might also face various punishments from civil torts to criminal responsibility.

1 answer
2026-11-16 12:10

Actress of the Everlasting Lovesickness Queen Mother

Yang Mingna played the role of the Queen Mother in " Long Lovesickness." Had he not watched enough of Long Lovesickness 2? Hurry up and read the original work of " Everlasting Lovesickness 2: A Vow of Love "!

1 answer
2026-11-16 12:10

What aspect of human nature does suspense reflect?

Suspense works often reflected many aspects of human nature: - * * Complicated and contradictory **: In suspense stories, the good and evil of the characters are not absolute. For example, in Keigo Higashino's "Malice," the murderer's hatred had no reason. Just because of the excellence of others, it produced extreme malice, showing the contradiction between the complex negative emotions such as jealousy and resentment in human nature and the usual appearance. - * * Dark Side **: Many suspense works reveal the darkness of human nature through layers of reversals. Movies like Translator's Cloud and The Female Corpse Mystery exposed the dark side of human nature, such as greed and selfishness. When faced with a crisis or the temptation of benefits, such as in "21 Days," the dispute over the distribution of resources under the ruins also reflected the dark side of human nature exposed in order to survive. - * * Fragility and mutable **: Some stories use family secrets or unexpected events as clues, such as the family secrets in the Mystery of Lisboa to show the fragility of human nature. The seemingly stable interpersonal relationships and people's beliefs could change dramatically under the impact of suspense. - * * Kindness and Beauty **: Although suspense works often involve dark elements, there is no lack of showing the beautiful side of human nature. In "21 Days," some people chose to sacrifice themselves at the critical moment of life and death, while others supported each other with love and courage. This was the embodiment of positive qualities such as kindness and courage in human nature. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-16 12:10

Is Golden Morning King Anyu really close?

From the exposed footage of " Blazing Road," Jin Chen and Wang Anyu were very involved in the kissing scene. For example, in the beach kissing scene, their interaction seemed very selfless, with many intimate movements and expressions. However, this was a performance during the filming process. In order to show the emotional relationship in the plot, the actors would use professional acting skills to show the intimate scenes. Although their performance looked very realistic, there was no conclusive evidence that they were really kissing and not acting. While waiting for the anime, you can also click on the link below to read the classic original work of The King's Avatar!

1 answer
2026-11-16 12:09

What are the names of the novels that start the mercenary group?

From the information provided, it was known that there were novels such as "Hero Tempered,""Son-in-law of the Emperor," and "Billions of people on the Blue Planet travel through the mercenary world"(according to the content, this may be a novel without an official title), which had the plot of the beginning of the mercenary group. However, whether the name sounded good or not was a subjective judgment. However, these names all had their own characteristics. For example,"Hero Tempered" conveyed the feeling that the protagonist had gone through many hardships to become a hero;"Son-in-law of the Emperor" was more straightforward and had a certain degree of drama to attract readers;"Billions of people on the Blue Planet crossed the mercenary world" directly pointed out the background setting of the story and had a strong summary of the story. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-16 12:09

Talisman picture exorcism

Based on the information provided, I couldn't find anything related to the picture. Sorry, I don't know how to answer based on the information I found. The Demon Expelling Order novel is equally exciting. Everyone is welcome to click and read it!

1 answer
2026-11-16 12:09

14th Five-Year Plan: County Assessment of National Key ecological functional areas

The state conducted an assessment of the ecological environment quality of the counties (districts) listed as key ecological functional areas, and the 14th Five-Year Plan period was no exception. The purpose was to reward the counties (districts) whose ecological environment quality had improved through the policy of paying equal attention to rewards and punishments, and deduct the transfer payment funds for the counties (districts) whose ecological environment quality had obviously deteriorated, so as to encourage the counties (districts) to strengthen the protection of the ecological environment. The assessment results are related to the central government's transfer payment quota to the county (district), which is of great significance to improve the ecological compensation standard and enhance the ecological environment protection effect. All regions will formulate work implementation plans according to the relevant notification requirements of the General Office of the Ministry of ecological environment and the General Office of the Ministry of Finance. The tasks include monitoring, evaluating, and assessing the quality of the county's ecological environment in accordance with the relevant requirements of the national and provincial financial and ecological environment authorities. Specifically, it includes establishing a leadership coordination mechanism for self-inspection work, clear division of responsibilities, and guarantee of work funds; Establishing a long-term mechanism for fund use management, coordinating the use of transfer payment funds, and reasonably arranging the implementation of projects; Organizing multiple departments to collect, summarize, and fill in assessment data, prepare self-inspection reports, and submit them on time; Be responsible for the compliance of fund use, the accuracy of relevant data, and the normativeness and completeness of self-inspection reports. Each department also had a corresponding division of responsibilities. For example, the Development Committee had to provide the development and implementation of the environmental impact assessment of the industrial park within the county. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-16 12:08

Enshi prefecture civil servants written examination training institution

Enshi Prefecture civil servant written examination training has public education and other institutions, which provide a variety of civil servant written examination training classes, such as public fame series classes, elite series classes, classic agreement series classes, basic improvement series classes, small private classes and many other series of Enshi civil servant training classes. There are also a variety of online classes and offline classes to choose from. In addition, there was also an organization specializing in civil servant training. It was committed to providing high-quality training services for students. Its main business included civil servant written test training. The team was composed of experienced professionals. They adhered to the business philosophy of "professionalism, focus, and concentration". They continuously optimized the curriculum system and improved the teaching quality based on the needs of students. They also established cooperative relationships with many universities in China to provide students with customized and differentiated training services. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-16 12:07
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z