excel - 30、60、90 天范围内的 COUNTIFS 问题

Question

我正在尝试在列中搜索文本，如果该项目从今天开始在 31-60 或 61-90 之间，但它不返回任何人可以提供帮助的任何计数？

=COUNTIFS(Sheet2!B2:B21,">="&TODAY()+31,Sheet2!B2:B21,"<="&TODAY()+60,Sheet2!A2:A21,"A")

=COUNTIFS(Sheet2!B2:B21,">="&TODAY()+61,Sheet2!B2:B21,"<="&TODAY()+90,Sheet2!A2:A21,"A")

标签： excelcountif