CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulasgoogle-formscountif
Efkam
Efkam

Reputation: 1

COUNTIF values in ROW with ArrayFormula -google form entry calculation

I am trying to count TEXT fields in my table filled by Formular. As I want to use this with document studio, copy if statement is not an option.

Working IF statement:

=((if(ISBLANK(B1:B991),"",if(row(B1:B991)=1,**"IF"**,COUNTIF(D2:BE2,"OK")))))

I need to put this to the arrayformula, adding data with form will delete all data in ROW(if statement is gone)

When I put this IF to arrayformula, it will calculate only values for first field.I need it to calculate values in each row.

Not working arrayformula:

=ArrayFormula(((if(ISBLANK(B1:B991),"",if(row(B1:B991)=1,**"ARRAZFORMULA"**,COUNTIF(D2:BE2,"OK"))))))

Link to the sheet: https://docs.google.com/spreadsheets/d/1_MipTVaI66KDrQq8w818AAb_tNvs8Ivm-TAucrYLDEs/edit?usp=sharing

Upvotes: 0

Views: 56

Answers (1)

player0
player0

Reputation: 1

try:

={"AF"; ARRAYFORMULA(MMULT(N(INDIRECT("G2:"&COUNTA(B:B))="OK"), 
 TRANSPOSE(COLUMN(INDIRECT("G2:"&COUNTA(B:B)))^0)))}

0

Upvotes: 1

Related Questions