Forum Discussion

JK_Aloha's avatar
JK_Aloha
Copper Contributor
Sep 07, 2022

Sum where Ax = Bx + Cx for the entire column A

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 ...
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 07, 2022

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

 

 

Resources