Google Sheets的拖动填充未根据突出显示的单元格正确计算。

huangapple go评论53阅读模式
英文:

Google Sheets Dragfill isn't properly calculating based on highlighted cells

问题

这是正确的公式样式。

单元格 B2 =SUM(Daily!B2:B6)
单元格 B3 =SUM(Daily!B7:B11)
单元格 B4 =SUM(Daily!B12:B16)

当我突出显示这三个单元格并向下拖动时,我希望单元格 B5 的公式填充为 =SUM(Daily!B17:B21)

但是,拖动下来会使其填充为 =SUM(Daily!B5:B9)

如何修复此问题以便能够拖动填充该列?

英文:

Google Sheets的拖动填充未根据突出显示的单元格正确计算。

This is what the formulas look like correctly.

Cell B2 =SUM(Daily!B2:B6)
Cell B3 =SUM(Daily!B7:B11)
Cell B4 =SUM(Daily!B12:B16)

When I highlight those 3 cells and drag down I expect Cell B5 formula to fill as =SUM(Daily!B17:B21)

Instead dragging down makes it populate as =SUM(Daily!B5:B9)

Google Sheets的拖动填充未根据突出显示的单元格正确计算。

How do I fix this so I can drag fill that column?

Also sorry if I didn't post this correct way. First time here.

Cheers

答案1

得分: 0

使用新的动态数组公式自动获取结果。尝试-

=MAP(SEQUENCE(100,1,2,5),SEQUENCE(100,1,6,5),LAMBDA(x,y,SUM(INDEX(Daily!B:B,x):INDEX(Daily!B:B,y))))

英文:

Use new dynamic array formulas to get results automatically. Try-

=MAP(SEQUENCE(100,1,2,5),SEQUENCE(100,1,6,5),LAMBDA(x,y,SUM(INDEX(Daily!B:B,x):INDEX(Daily!B:B,y))))

答案2

得分: 0

你也可以使用 OFFSET

=MAP(SEQUENCE(ROUNDUP(COUNT(Daily!B2:B)/5),1,0,5),LAMBDA(_,SUM(OFFSET(Daily!B2:B6,_,))))
英文:

You could also use OFFSET.

=MAP(SEQUENCE(ROUNDUP(COUNT(Daily!B2:B)/5),1,0,5),LAMBDA(_,SUM(OFFSET(Daily!B2:B6,_,))))

huangapple
  • 本文由 发表于 2023年6月9日 06:47:24
  • 转载请务必保留本文链接:https://go.coder-hub.com/76436160.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定