UC知道excel 公式填充失效
来源：百度知道 编辑：UC知道 时间：2024/06/15 15:33:03
为了统计多个区域“11”单元格的数量，我的公式为：
=SUM(COUNTIF(INDIRECT({"F2:K2","P2:AC2","AE2:BB2","BG2:BW2","CA2:CE2","CW2:DE2","DH2:DV2","DX2:DY2","EL2:FC2","FH2:FK2","FN2:GC2","GM2:GO2"}),"11"))
但是公式不能向下填充，请问怎么解决？
公式本身没错，可以达到效果的，但是为了统计每行的数量，希望能向下填充
=SUM(COUNTIF(INDIRECT({"F2:K2","P2:AC2","AE2:BB2","BG2:BW2","CA2:CE2","CW2:DE2","DH2:DV2","DX2:DY2","EL2:FC2","FH2:FK2","FN2:GC2","GM2:GO2"}),"11"))
但是公式不能向下填充，请问怎么解决？
公式本身没错，可以达到效果的，但是为了统计每行的数量，希望能向下填充
=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"))
是不是写错啦
你这个公式本身就是错的，运行结果永远是0.自己用公式审核工具看下演算过程。最后就是sum一堆0
你把"F2:K2"这种的改成
"F"&row(a2)&":K"&row(a2)
就可以了
其他的都按照这个改下
你在公式中已经引用了多个区域,说明你已经对该表中各个区域中符合条件的单元格进行了统计,那么为什么还要向下填充呢?应该是没有必要了!