COUNTIFS语句= COUNTIFS(V60:V91，"=>"& 0，V60:V91，“< ="& 30) [英] COUNTIFS statement, =COUNTIFS(V60:V91, ">="&0,V60:V91,"<="&30)

问题描述

我正在尝试使用COUNTIFS语句

I'm attempting a COUNTIFS statement,

=COUNTIFS(V60:V91, ">="&0,V60:V91,"<="&30).   

我相信我在语法上犯了错误，但我找不到它.你知道我在做什么错吗?

I believe I'm making syntactical error, but I can't finding it. Do you know what I'm doing wrong?

推荐答案

基于问题中的注释，如果您要计算一个月中的某天大于或等于零的日期(这将是全天)，以及小于或等于30的天...因此除31日以外的所有天数.如果这是错误的解释，请告诉我们.以下公式基于您的日期存储为数字并格式化为显示为日期而不是存储为文本的日期的方式.

Based on the comments in your question, you can try this if you are trying to count dates where the day of the month is Greater than or equal to zero (which would be all days), and the days that are less than or equal to 30...so all days except the 31st. If this is wrong interpretation, let us know. The following formula is based on your dates being stored as numbers and formatted to display as a date and not a date stored as text.

=sumproduct((day(V60:V91)>=1)*(day(V60:V91)<=30))

这篇关于COUNTIFS语句= COUNTIFS(V60:V91，"=>"& 0，V60:V91，“< ="& 30)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！