Read More: Daily Income and Expense Sheet in Excel Insert the formula of SUM functions into that cell.So, select the cell where you want to see the result of total expense.In Excel, the SUM function sums the digits in a group of cells. Now, for calculating the daily expense for each category, we are going to use the SUM function in Excel.Further, fill all the categories and subcategories and the total amount spent for each category.As a result, you can see in cells D6 through D11, that there is a drop-down list with all of your spending categories.Lastly, press the OK button to finish the process.Afterward, refer to the C5:C16 fields from the Expense Categories worksheet, in the Source text box.Then, from the Allow choices, select the List option.Now, from this window, select the Settings tab.The Data Validation window will now show up.Thirdly, select the Data Validation drop-down box under the Data Tools category.Likewise, in the previous steps, choose the Sub Category column then, go to the Data tab from the ribbon.Creating a drop-down list similarly to the expenses subcategory is the next step.Instead of writing it down every time, you may choose your expense category from this page with only one click. From there, you can easily select any category. Thus, if you click on the category cell, you will be able to see a tiny drop-down icon.For this, go to the Categories sheet and select range B5:B16. In the Source field select the range of categories listed.Now, from the Allow drop-down option, choose List.Subsequently, go to Settings from the menu.As a result, this will appear the Data Validation dialog box.Thirdly, from the Data Tools group, click on the Data Validation drop-down menu.
Secondly, select the Category column and go to the Data tab from the ribbon.
Here, we merge the cells as we use only one date.
Please find a link to Currencycloud’s terms of use here. Registered Office: 104 5th Avenue, 20th Floor, New York, NY 10011. The Currency Cloud Inc is registered with FinCEN and authorized in 39 states to transmit money (MSB Registration Number: 31000206794359). CFSB is registered with the Federal Deposit Insurance Corporation (FDIC Certificate #57129). which operates in partnership with Community Federal Savings Bank (CFSB) to facilitate payments in all 50 states in the US. For clients based in the United States, payment services for Teampay Corporation are provided by The Currency Cloud Inc. In such cases, funds may not be fully insured in the event the insured depository institution where the funds have been deposited were to fail. Pass-through insurance is only available if certain conditions have been met, and there may be a risk that pass-through deposit insurance is not available because conditions have not been satisfied. FDIC insurance is available on customer funds through pass-through insurance at Choice Financial Group, Member FDIC where we have a direct relationship for the placement of deposits and into which consumer funds are deposited. The Teampay Card is issued by Choice Bank, which is a division of Choice Financial Group, Member FDIC, pursuant to licenses from Mastercard.