计算当前月份使用”MONTH(“Oct”&1)”不正常。

huangapple go评论84阅读模式
英文:

Count current month with "MONTH("Oct"&1)" not working correctly

问题

=ARRAYFORMULA(COUNTIFS(MONTH(PHXOctober!D:D),MONTH("Oct"&1),PHXOctober!L:L,"Jeremy")) - 这是我正在使用的公式,它似乎在计数时是正确的,但当我使用CTRL F查找所有十月的内容时,它稍微有点偏差。

在我的函数中使用 MONTH("Oct"&1) 是不正确的吗?我只想要计算整个十月份中所有带有我的名字的内容的数量。

英文:

I'm trying to count how many entries I have on a sheet within a month range.
=ARRAYFORMULA(COUNTIFS(MONTH(PHXOctober!D:D),MONTH("Oct"&1),PHXOctober!L:L,"Jeremy")) - This is the formula I'm using, and it seems to be counting correctly, but it's slightly off when I CTRL F everything from October.

Am I wrong for using MONTH("Oct"&1) in my function? I just want a count with everything that has my name on it for the full month of October.

答案1

得分: 1

你的公式是正确的,使用 MONTH("oct"&1) 也是正确的

尝试:

=COUNTA(QUERY(PHXOctober!D:L, "select D where L = 'Jeremy' and month(D)+1 = 10"))
英文:

your formula is correct and usage of MONTH("oct"&1) is also correct

try:

=COUNTA(QUERY(PHXOctober!D:L, "select D where L = 'Jeremy' and month(D)+1 = 10"))

huangapple
  • 本文由 发表于 2020年1月3日 15:10:07
  • 转载请务必保留本文链接:https://go.coder-hub.com/59574525.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定