I have this data in Gooogle Sheets:

I want to transpose and sum the rows in an array formula?

https://docs.google.com/spreadsheets/d/1u3FcZicBP2I1anMyUdFfWscfETOuREGewPr_HSqbQY0/edit#gid=284528632

How I can achieve this in Google Sheets?

>Solution :

You may try:

=byrow(B13:F30,lambda(z,if(counta(z)=0,,scan(,filter(z,z<>""),lambda(a,c,a+c)))))