发布网友 发布时间:2022-04-24 07:35
共5个回答
热心网友 时间:2022-06-17 16:08
你把"F2:K2"这种的改成
"F"&row(a2)&":K"&row(a2)
就可以了
其他的都按照这个改下
热心网友 时间:2022-06-17 16:08
你在公式中已经引用了多个区域,说明你已经对该表中各个区域中符合条件的单元格进行了统计,那么为什么还要向下填充呢?应该是没有必要了!
热心网友 时间:2022-06-17 16:09
你这个公式本身就是错的,运行结果永远是0.自己用公式审核工具看下演算过程。最后就是sum一堆0
热心网友 时间:2022-06-17 16:09
=SUM(COUNTIF(INDIRECT({"F","P","AE","BG","CA","CW","DH","DX","EL","FH","FN","GM"}&ROW(A2)&":"&{"K","AC","BB","BW","CE","DE","DV","DY","FC","FK","GC","GO"}&ROW(A2)),"11"))
热心网友 时间:2022-06-17 16:10
是不是写错啦