ArrayFormula 自动计算一列 [英] ArrayFormula to automatically calculate one column

问题描述

我想要一个数组公式与 Google 表单数据一起使用，以自动计算我的数据的运行指标.

在这种情况下，在 Q、AE 和 AS 列中，我希望它在有新回复时自动计算.

我正在尝试使用下面的这个公式，但不适用于所有列，仅适用于第一行.

={arrayformula(if(len(AF3:AF);SUM(vlookup(AF3:AR3;$A$1100:$B$1101;2;0));))}

我想要包含Verdadeiro"的所有单词的总和；连续.

我做错了什么?

我的 Google 表格:

I want an array formula to use with Google Forms data to automatically calculate running metrics on my data.

In this case, in column Q, AE and AS I want it to auto-calculate whenever new responses come in.

I'm trying to use this formula below but isn't working for all column, just for the first line.

={arrayformula(if(len(AF3:AF);SUM(vlookup(AF3:AR3;$A$1100:$B$1101;2;0));))}

I want a sum of all words that contain "Verdadeiro" in a row.

What I'm doing wrong?

My Google Sheet:

https://docs.google.com/spreadsheets/d/1AVQ772IIXI-xZza0fecTTCe4S-Ku9rL1houTMnQZpbo/edit?usp=sharing

解决方案

try in row 1:

={"Total AG";""; ARRAYFORMULA(IF(A3:A="";;
 MMULT(N(REGEXMATCH(A3:AR&""; "Verdadeiro")); SEQUENCE(COLUMNS(A3:AR))^0)))}

这篇关于ArrayFormula 自动计算一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！