今天分享几个统计成绩常用的Excel函数公式，让分数统计分析变得不再麻烦，可以直接套用哟！当然也可以用于公司销售业绩统计分析。

01.计算总分

计算总分也就是对每一名学生的三科分数进行求和，以前讲过Alt+=键可以快速求和，今天要分享的是求和公式。

在H2单元格输入公式：

三大计数函数实战秘籍，轻松搞定各类统计需求COUNT、COUNTIF、COUNTIFS 这三个公式函数，计数统计虽看似基础，实则是支撑起整个分析大厦的关键基石。无论是严谨的考勤统计，还是复杂的销售分析，掌握正确的计数函数都能让你事半功倍。今天，我们就通过真实的案例，深入剖析 Excel 中三大实用的计数函数，助你成为数据统计的高手。

The People's Government of Daoxian County successfully challenged the Guinness World Record for "Dragon Boat Race with the Largest Number of Participants" on June 2, 2024. The Guinness World Records judge confirmed on the site that the number of participating dragon boats reached 212. The photo shows dragon boats mustering on the Xiaoshui River in Daoxian County on that day. (Photo/Jiang Keqing)

The aerial photo above, taken on August 28, shows the Xiaodukou Pumping Station (the high-rise part of the building that spans the river) and its sluice gates in Xiaodukou Town, Lixian County. The Xiaodukou Pumping Station was tested for drainage on the same day. The construction of the pumping station started in October 2019. It is currently the largest of its kind in Hunan Province. The pumping station is designed to discharge a flow of 294 cubic meters per second, with six generators and an installed capacity of 20,700 kilowatts. After put into operation, it can benefit Lixian County, Jinshi City, Linli County, and the Cendan Farm, covering a protection area of 785 square kilometers. (Photo/Bo Yipu and Xiao Lihua)

3月1日，香港启德体育园正式启用。该项目占地28公顷，包含5万座主场馆、1万座体艺馆及5000座青年体育场三大核心场馆，是香港规模最大的体育及文娱综合体，将作为第十五届全国运动会重要赛事场地，进一步提升香港承办国际大型活动的能力。

Kai Tak Sports Park commenced operations today. Spanning 28 hectares, the project comprises three core venues: a 50,000-seat main stadium, a 10,000-seat multipurpose arena, and a 5,000-seat youth sports ground. As the city's largest integrated sports and entertainment complex, it will serve as a key venue for the 15th National Games, further bolstering Hong Kong's capacity to host major international events.

2021-01-21 | China Economic Net

China's online retail sales of goods rose 14.8 percent year on year to 9.8 trillion yuan (about 1.5 trillion U.S. dollars) in 2020, data from the Ministry of Commerce (MOC) showed Tuesday.

每个合数都可以写成几个质数相乘的形式，其中每个质数都是这个合数的因数，叫做这个合数的分解质因数。 分解质因数只针对合数。今天算法是关于质因数分解的，其中我们不仅要有一个函数用于判断质数，还要把一个比较大的数字分解出他的质因数，并得到那个最大的质因数。

A003. Largest prime factor

At noon on April 10, the world's largest container ship "Mediterranean Irina" (MSCIRINA) developed independently by China berthed at the Nansha Phase II Container Terminal in Guangzhou Port. Only 17 days later, the ship with a maximum loading capacity of 24,346 TEUs once again broke the historical record of the largest container ship docked in Nansha Port.

In 2024, Shandong Port Group hit a major milestone, handling over 1.8 billion tons of cargo and 44 million TEUs. This pushed Shandong’s coastal ports past 2 billion tons, securing its top spot among China’s coastal provinces for the third year running. In 2025, Qingdao Port, a key subsidiary, set its 13th global efficiency record for automated container terminals, cementing its industry leadership.

LCP 全称 “Largest Contentful Paint”，翻译为“最大内容绘制”，用于监控网页可视区内“绘制面积”最大的元素开始呈现在屏幕上的时间点。

最大内容绘制，LCP（Largest Contentful Paint），用于记录视窗内最大的元素绘制的时间，该时间会随着页面渲染变化而变化，因为页面中的最大元素在渲染过程中可能会发生改变，另外该指标会在用户第一次交互后停止记录。