Ravi Sir's Cards › Excel
Monthly Home Budget in Excel (card 2 of 2)
Revision card 2 for Monthly Home Budget in Excel: Whole-month difference: =C24-D24 gives −₹1,030; Total planned: =SUM(C11:C23) gives ₹96,200; How many heads went over: =COUNTIF(F11:F23,"Over")&" over" gives 3 over. Includes an example data table.
Read card text
What this card says
2 for Monthly Home Budget in Excel: Whole-month difference: =C24-D24 gives −₹1,030
Total planned: =SUM(C11:C23) gives ₹96,200
How many heads went over: =COUNTIF(F11:F23,"Over")&" over" gives 3 over. Includes an
Example
data table
Learn this in the lesson: How to Make a Monthly Home Budget in Excel (Planned vs Actual, Savings and Overspending Alerts)