Pages tagged “dashboard”

3 pages in Cellwise.

1. Monthly totals by category with SUMIFS and EDATE

   Build a category-by-month grid from a list of transactions with one SUMIFS formula you can fill across and down.

   sumifs dashboard dates

2. Running balance formula for income and expenses

   A running total down a column: income so far minus spending so far.

   budget dashboard balance

3. Share of total and percent change formulas

   What share of the total a row is, and how much it changed from the previous row.

   percent dashboard

All pages