CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Prudhavi
Prudhavi

Reputation: 47

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

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.

Upvotes: 0

Views: 42

Answers (1)

Harun24hr
Harun24hr

Reputation: 36880

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))

Upvotes: 1

Related Questions