Count rows from other table (COUNTIF)

[Luis_Gomes_Mac1]

Hi Everyone,

I need help with an expression.
I have a table “Familias” which have a key [ID Familia] and another column [Quantidade Elementos Agregado]
another table “Elementos da Familia” which have a key [ID Elemento Familia] has a Column [ID Familia] that is a “REF a part of” the first table “Familias”
I need the Familias[Quantidade Elementos Agregado] to calculate the amount of rows REFed on Elementos da Familia[ID Familia].

can someone help me as Appsheet doesn’t accept COUNTIF

thanx

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I do COUNTIF() or COUNTIFS()? COUNTIF(col, expr), where col is a whole-column reference (e.g., A), is similar to: COUNT( FILTER( "table", ([col] expr) ) ) COUNTIFS(col1, expr1, col2, expr2, ...), where col1 and col2 are each whole-column references, is similar to: COUNT( FILTER( "table", AND( ([col1] expr1), ([col2] expr2), ... ) ) ) To limit the rows included in the COUNT() range (e.g., as with COUNTIF(A3:A7, ...)), include the limit crit…

[Rafael_ANEIC-PY]

Hello @Luis_Gomes_Machado, try:

COUNT([Related Elementos da Familia])