Sep 06 2022 09:32 PM
Hello.
As the subject states I am trying to input a command where the Sum of Bx + Cx is displayed in Ax where X is the row number.
I understand I can manually enter A1 = B1 + C1 etc. This is an overly time consuming activity.
I would like to enter a single formula such that Ax = Bx + Cx where X = the row number between a range; for example between rows 8 and 150.
Thanks.
Sep 06 2022 10:10 PM
@JK_Aloha It is only possible if you are Microsoft-365. You can simply use in A2 cell as per my screenshot.
=B2:B13+C2:C13
Or can use BYROW() function like-
=BYROW(B2:C13,LAMBDA(x,SUM(x)))