=countifs(a:a,"今日",b:b,"<>码告"棚模源链态)
2003版本：=sumproduct((A2:A4="今日")*(B2:B4<>""))注意：范围A2:A4和B2:B4大小范液宴围必须一致2007以上：雀慎=countifs(A:A,"今日",B:B,"<>"闹岁银)
