How do I apply this formula =COUNTA(D3:R3)/3 to all cells using ARRAYFORMULA In Google Sheets

Question

I want to apply the above formula to all the rows in a single column, however, unable to do so since arrayformula takes range and so does counta.

I tried applying brackets over the counta({D3:D},{R3:R}) but it didn't work.

Answer 1

Use BYROW() function to iterate all rows and use other function to calculate per row result. Try-

=BYROW(D3:R,LAMBDA(rw,COUNTA(rw)/3))