Home Business Expense Spreadsheet
How do I change a formula on existing Excel spreadsheet ?
I have what I guess is referred to as a workbook with 3 pages labeled; Income, Expenses, Sched. C Expenses. The Income sheet list customers and carries over totals to the Expenses sheet to show either a + or – for the bottom line. I acguired this workbook from another in the home business field.
Problem: I need to add more rows and have my “floating” last row be always tranferred to the other sheet. Current formula is =SUM(B3:B83) I need to know how to make it =SUM(B3:infinity)
One of the things you can do is name the rnge that has all the customers. Then on the expenses sheet the formula for SUM should be =sum(cust) or whatever you choose for a name.
Now, in the list, you can do what one of the other answers suggests to insert blank rows to add more names. As long as you insert rows anyplace in the middle of your range you will maintain the range name which means you never have to fiddle with the SUM formula on the other sheet. Just remember you can’t insert rows in front of top of list or after last row of list.
HiE Budget Analysis – Property Portfolio
Download "3 Secrets Of Millionaires" For Just $9.97 For a Limited Time. Click Here For Details!