试试这个吧=SUMPRODUCT(--(MONTH(T126:T128)=MONTH(TODAY())))
在SUMPRODUCT中逻辑值好像不会自动转为0或1
如果不行再来讨论,
excle中 =SUMPRODUCT(MONTH(T126:T128)=MONTH(TODAY()))这个公式有错吗,为
1个回答
相关问题
-
sumproduct函数问题=SUMPRODUCT(--(MONTH('BJ - 商店A'!$E$4:$E$998)&"
-
There are( t ) months in a year There are( t ) months in a y
-
有The next month这个单词吗,和 next month有什么区别
-
We have four months this t____.补充
-
may is the fifth month in a year.may is the fifth month of t
-
December is the (t ) month of the year.
-
I don't cut my hair ()two months
-
There are about 28 t in a month.
-
The printer didn't sold last month(改错)
-
i haven’t seen jim since last month.提问_______ ________ _____