where I loan my friend non interest purchases that eventually I will receive a cash payment that will allow the spreadsheet to show that purchases are now fully paid and any short falls indicated until next cash payment
A very simple option:
Type =SUM(B$3:B3)in C3, press Enter, click in C3, and drag down the little black square (fill handle) to fill down the formula.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).