![]() Quick visualization of category level spendingĪs you enter values, you can see a quick total (arrived thru the formulas explained above) and a data bar. Read up more about SUMIFS and SUMPRODUCT formulas.Ģ. If there is an error (typos / no data etc.) we show 0. We then multiply that with amounts in G7:G26 thru SUMPRODUCT and finally divide this with 12 to get monthly value. We are fetching an array of multiplication factors from freqs table (shown aside) using SUMIFS. Say you have amounts in G7:G26 and frequencies in H7:H26. Using SUMPRODUCT and SUMIFS, we can calculate total amount per category by month, like below.There is a frequency mapping table in the “Settings” tab to help calculate monthly totals from various amounts at different frequencies.Calculation of monthly totals by category: There are three components in the budget spreadsheet:ġ. The graph on left helps you see the big picture and optimize your spending / savings. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |