![]() As we want the amounts to be in the correct category, on or after the beginning date, and on or before the ending date, we will use SUMIFS to match those three conditions.Ĭ3: =SUMIFS(Transactions::D,Transactions::C,A3,Transactions::A,">="&B$1,Transaction s::A,"<="&D$1) The formula in column C of the template uses SUMIF, as the amounts need to match only the category to be included in the sum. ![]() (In the version shown, I used Nov 15 and Nov 30 of 2014 to include only some of the dates on the table supplied with the Numbers 3.6.2 template's sample transactions.) On January's table, these dates would be and Jan 31, 2017. If that is the case, the formula in column B of the new table should be a simple transfer and eliminate the /12 part.Ĭolumn C: This column will contain the expenditures occurring in the period between the dates in B2 and D2 in each of the categories. ![]() ![]() The instructions below assume that you will KEEP the original Budget table and use it to ENTER your MONTHLY budgeted amounts for each month. During the pause, I reread the Budget page of the template, and realized the table there was intended to contain a monthly budget, not an annual budget. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |