countifs in excel 在 Excel CountIfs with an or condition on Dates - Stack Overflow 的評價 use: =SUMPRODUCT(--((Query1[Purchased Date]="")+(Query1[Purchased Date]>A5)>0)). ... <看更多>