英文:
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"))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论