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
The Countif function could be used to quickly calculate the attendance days in the attendance sheet. For example, if you use a tick (tick) to record attendance, assuming that attendance is recorded in the cell area C5 to AG5, then the formula for counting the number of days of attendance is =Countif(C5: AG5,"tick"). In addition, you can also use the IF function. For example, according to the attendance status, if the employee is present on the day, it will return 1 day. If the employee is absent on the day, it will return 0 days. The formula is =IF.(Attendance status ="On duty", 1, 0). You can also use the SUM function to calculate the number of days of attendance within a certain time range. For example, you can use the SUM function to calculate the number of days of attendance within a month. The formula is =SUM.(Screen out the cells with the status of "On duty" in the attendance sheet), or use the Count function to count the number of non-empty cells within a certain range to calculate the number of attendance days. For example, the formula for counting the attendance days of employees in a certain department is =Count(Screen out the cells with the status of "On duty" and the department is "a certain department" in the attendance sheet). <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
There may be errors in the total days formula of the attendance sheet due to the following reasons: * * 1. The problem with the function formula itself ** 1. * * Syntactic error ** - If you use functions such as Countif, there may be errors in the writing of regions or conditions. For example, the cell range of the region was selected incorrectly, and the cells that needed to be counted were not included correctly; or in the condition section, if it was a text condition, the double quote was not correctly added, and so on. 2. * * Function logic error ** - For example, when calculating the number of days of attendance, the formula might not accurately consider all the factors that affect attendance. The correct calculation formula for attendance days should be attendance days = total days-days on leave-days absent from work-times late and leave early (converted according to the company's regulations). If the formula was not constructed according to this logic, an error would occur. 3. * * Data type does not match ** - If there was an improper calculation between numbers and text in the formula, such as using numbers and cells that contained text format for calculation, it might cause the formula to make mistakes. * * 2. Problem with the data itself ** 1. * * False Empty Cell ** - When the attendance sheet was imported into excel from other software, there might be false empty cells, which were cells that looked empty but actually contained some invisible characters or formula conversion values. These false empty cells might affect the statistics function. For example, when the Counta function was used to count the number of non-empty cells, if there were false empty cells, the statistics result would be wrong. 2. * * Data format problem ** - If the data format such as date, time, or number did not meet the requirements of the formula, it could also cause the formula to be wrong. For example, setting a negative number to a date or time format might cause the formula to have an error value of #####. * * 3. Problems with software or equipment ** 1. * * Software compatibility ** - If the software or equipment used does not support the automatic calculation of the number of days absent, it may cause the formula to be wrong. For example, some versions of excel or other office software may have compatibility problems when processing specific formulas. 2. * * Software Failure or Bug ** - Although it was rare, the software itself might have faults or bugs that affected the normal calculation of the formula. If there is an error in the total days formula of the attendance sheet, you can take the following solutions: 1. * * Check the grammar and logic of the formula ** - Carefully check the grammar of the function formula to ensure that the region and conditions are written correctly. As for logical errors, he had to reconstruct the formula according to the correct logic to ensure that all factors affecting the total number of days were considered. 2. * * Dealing with data issues ** - For the problem of false empty cells, you can open the Find window by pressing the Control + F key. You don't need to enter anything for Find and Substitute. You can directly press Find All, then press the Control + A key to select all the "empty cells", and then press the delete key to delete these possible false empty cells. After that, you can check if the formula is normal. If it was a data format problem, adjust the format to a suitable format according to the data type, such as adjusting the date format to a regular format. 3. * * Checking software or device problems ** - If you suspect that it's a software compatibility problem, you can try opening the attendance sheet in a different software version or office software to calculate. If it is a software malfunction or bug, you can try to restart the software or update the software version. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
In 2024, there were 251 working days. The novel " Hundred Years of Spaceship " is equally exciting. Everyone is welcome to click and read it!
The year 2024 was a leap year, and the number of days could be calculated according to the definition of a leap year and the number of days in a month. According to the definition of leap year, if a non-hundred-year could be divided by 4, it was a leap year. 2024/4 = 506, so 2024 is a leap year. Looking at the number of days in the month, January, March, May, July, August, October, and December had 31 days, April, June, September, and November had 30 days, and February had 29 days in leap years. The calculation was: 7×31+4×30 + 29 = 217+120+29 = 366 days. In total, there were 366 days in 2024. The novel "Hundred Years of Spaceship" is equally exciting. Everyone is welcome to click and read it!
If you want to perform cross-row sums on the cells in the odd rows such as the 1st, 3rd, and 5th rows in each column, you can select the cell where the calculation result needs to be placed, enter the formula = SUMPRODCT ((A1:A6)*(MOD(Rows (A1:A6),2)=1)), and then press the Enter key to end the input. You will get a calculation result, then select the cell, and use the mouse to pull the fill handle to the right to fill in the formula to get the sum results of other columns. The SUMPRODUCT function in the formula was used to return the product of the array. A1:A6 was the region of the cell to be calculated. MOD(Rows (A1:A6),2)=1 was used to select whether the row was an odd row. If it was, the function would return True, and the corresponding cell would be recorded in the sum term, and the even term would not be counted. If it was a cross-line sum of regular text in front of numbers, you could use the formula =Sumif(C4:C19,C4,D4). Sumif was a function that summed according to conditions. It could sum column D according to the text in column C. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Countif function can be used to calculate attendance days in Excel. For example, if the attendance status is represented by a specific symbol (such as "tick"), to calculate the number of days of attendance in a row (assuming it is the cell area C4: AG4), the formula is: =Countif(C4: AG4,"tick"). If you want to consider situations such as being late and leaving early, for example, being late is represented by "°", and the formula for counting the number of days late is =CountiF(C4:AG4,"°"); leaving early is represented by "°", and the formula for counting the number of days left early is =CountiF(C4:AG4,"°"). In addition, according to different working hours, overtime, leave time, and other factors, the calculation formula for the number of attendance days would be different. Under the standard working hours system, the average working days were 20.83 days per month. If the actual attendance of the employee is considered, when calculating the salary, the calculation of the attendance days also needs to take into account overtime (overtime on workdays is calculated at 1.5 times the salary, overtime on weekends is calculated at 2 times the salary, and overtime on legal holidays is calculated at 3 times the salary. Overtime can be added to the actual attendance days) and leave (sick leave, personal leave, etc. will be deducted from the actual attendance days). If you want to calculate the number of working days between two dates (which can be used to calculate the number of days of attendance), you can use the COMPUTAKDays function. The grammar is COMPUTAKDays (start_date,end_date,[holidays]). <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Counting Days was a song sung by Gong Yue. The lyrics and track were all composed by Chen Yue. The lyrics of the song described the busy life and the idea that people should cherish every step of the way. Although there was no specific song score in the search results provided, the lyrics could be used to appreciate the song.
In 2024, the number of days of salary calculation was 21.75. Even if the legal holidays on November 10th, 2024 were changed from 11 days to 13 days (adding 1 day of legal holidays on Labor Day and 1 day of legal holidays on Chinese New Year's Eve), the number of days of monthly pay would still not be affected. The calculation method was: days of monthly pay =(365 days- 104 days) div12 = 21.75 days (104 days are weekends throughout the year, excluding legal holidays, 52 weeks x 2 days/week = 104 days of weekends). The novel "Hundred Years of Spaceship" is equally exciting. Everyone is welcome to click and read it!
In the information provided, the number of days was not related to the number of years. The number of days had different meanings in different concepts. For example, the number of days in the Book of Changes symbolized yin and yang things, and it also had the meaning of calculating dates and working days. There was no expression related to a hundred million years. Therefore, the number of days was not a hundred million years. The novel " Ten Years of Death " is equally exciting. Everyone is welcome to click and read it!
Blade Fangs 3 Days and 3 Nights was the 24th episode of the first season of Blade Fangs.