Apr 04 2019 06:57 AM
In the attached spreadsheet, I have set up the formula to sum the set of numbers in column A until a negative number is encountered in row 5. I need to have the formula in the adjacent columns to sum to the same row irrespective of whether the number is positive or negative. The answer in Column B should be $31 and the answer in Column C should be ($63). I would appreciate any thoughts.
Apr 04 2019 07:37 AM
Apr 04 2019 08:32 AM
@TwifooThank you for responding. Your answer worked given the information I gave earlier but I realize now that the parameters were not set up correctly. I've attached another spreadsheet with more accurate parameters. If I use your formula with the new set of numbers, the returned answer is not correct.
Apr 04 2019 09:17 AM
SolutionApr 04 2019 09:38 AM
Apr 04 2019 10:01 AM
Apr 04 2019 09:17 AM
Solution