What would be the proper syntax if the formula =SUM(A2:A(ROW-1)) in cell B5 is incorrect?
I have two columns of positive values with no decimals, A and B. I have these values in column A, starting with A2. Let's say A2 is 10, A3 is 20, and A4 is 5.
I want to use the following formula in the cells of column B to add the values from column A together: B3 would be the "sum" of A2 (10), B4 would be the sum of A2 and A3 (30), B5 would be the sum of A2 and A3 and A4 (35), and so on.
I always need to add up all the values in column A, from A2 up to the current row minus 1, which is why I created the above formula, but it is incorrect. The MS "help" that then opens up is also of no assistance, and I was unable to find any information online about "Excel SUM ROW" or similar functions.
I tried several different syntaxes, but they were all awful, such as =SUM(A2:A(ROW()-1)) and using  in place of () around ROW-1.
Please let me know the correct syntax.