I am using below formula in cell B2, the formula works fine, but when I try to use the formula with arrayformula it gives incorrect result.
=IF(ISBLANK(B2),"",COUNTA($B$2:B2))
Below is the lint for the sheet
https://docs.google.com/spreadsheets/d/1jaPk6MhhUxIQAvU0VPdXlWTEn0sjTdasapTkCsCma1o/edit#gid=0
Any help on above will be appreciated.
Here is a fairly straightforward approach:
=ArrayFormula(IF(B2:B="",,COUNTIFS(B2:B,"<>",ROW(B2:B),"<="&ROW(B2:B))))
It basically reads "If any cell in Column B is blank, leave the return blank; otherwise count the non-blank entries in Column B including only content in rows less than or equal to the current row number."
Try this in cell A1 (delete allcontent below):
=arrayformula({"Sr.No.";iferror(vlookup(
if(B2:B<>"",row(B2:B),),
{filter(if(B2:B<>"",row(B2:B),),if(B2:B<>"",row(B2:B),)<>""),sequence(count(if(B2:B<>"",row(B2:B),)),1)}
,2,0),)})
Try
=arrayformula(if(B2:B="",,mmult(1*(transpose(row(B2:B))<=row(B2:B)),IF(B2:B="",0,1))))