Excel-统计日期内的个数1月到12月

使用函数COUNTIFS（范围,"条件",范围,"条件"）=COUNTIFS(Sheet!F2:F230,">=2024-01-01",sheet!F2:F230,"<=2024-01-31")=COUNTIFS(sheet!F2:F230,">=2024-02-01",sheet!F2:F230,"<=2024-02-29")=COUNTIFS(sheet!F2:F230,">=2024-03-

LCG元

6525人浏览 · 2024-09-25 15:39:10

LCG元 · 2024-09-25 15:39:10 发布

使用函数COUNTIFS（范围,"条件",范围,"条件"）

=COUNTIFS(Sheet!F2:F230,">=2024-01-01",sheet!F2:F230,"<=2024-01-31")
=COUNTIFS(sheet!F2:F230,">=2024-02-01",sheet!F2:F230,"<=2024-02-29")
=COUNTIFS(sheet!F2:F230,">=2024-03-01",sheet!F2:F230,"<=2024-03-31")
=COUNTIFS(sheet!F2:F230,">=2024-04-01",sheet!F2:F230,"<=2024-04-30")
=COUNTIFS(sheet!F2:F230,">=2024-05-01",sheet!F2:F230,"<=2024-05-31")
=COUNTIFS(sheet!F2:F230,">=2024-06-01",sheet!F2:F230,"<=2024-06-30")
=COUNTIFS(sheet!F2:F230,">=2024-07-01",sheet!F2:F230,"<=2024-07-31")
=COUNTIFS(sheet!F2:F230,">=2024-08-01",sheet!F2:F230,"<=2024-08-31")
=COUNTIFS(sheet!F2:F230,">=2024-09-01",sheet!F2:F230,"<=2024-09-30")
=COUNTIFS(sheet!F2:F230,">=2024-10-01",sheet!F2:F230,"<=2024-10-31")
=COUNTIFS(sheet!F2:F230,">=2024-11-01",sheet!F2:F230,"<=2024-11-30")
=COUNTIFS(sheet!F2:F230,">=2024-12-01",sheet!F2:F230,"<=2024-12-31")