level 1
北野肆fB
楼主
如果，第二行的月份和周都是公式显示的。C2="Subtotal of "&TEXT(TODAY(),"mmmm")
D2="Subtotal of Week "&WEEKNUM(EOMONTH(TODAY(),-1)+1,1)
C3=COUNTIFS($A$2:$A$110,"<>",$A$2:$A$110,">="&VALUE("2013/"&TEXT(TODAY(),"mm")&"/1"),$A$2:$A$110,"<"&VALUE("2013/"&TEXT(TODAY(),"mm")+1&"/1"))
可是D3为什么不能正常显示呢，哪里有问题？
D3=COUNTIFS($A$2:$A$110,"<>",$A$2:$A$110,"WEEKNUM(EOMONTH(TODAY(),-1)+1,1)")
求各位老师帮忙~~~~万分感谢。
