Spreadsheet: 545025d1509182027-sumifs-formula-for-monthly-and-annual-summation-that-doesnt-require-an-additional-column-2015-2016-2017-sample-workbook
Sheet: Per month

 |  |  |  |  |  | 2016
2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018 | 2019 |  | Pot
 |  |  |  |  |  | Wages
 |  |  |  |  |  | Rental
 |  |  |  |  |  | Vouchers, refunds
 |  |  |  |  |  | Income
 |  |  |  |  |  | Mortgage/rent
 |  |  |  |  |  | Interest
 |  |  |  |  |  | Payback on principel
 |  |  |  |  |  | Utilities
 |  |  |  |  |  | Cable, internet, fax & land line home
 |  |  |  |  |  | Cell phone
 |  |  |  |  |  | Landline
 |  |  |  |  |  | Home repairs
 |  |  |  |  |  | Home improvement
 |  |  |  |  |  | Appliances
 |  |  |  |  |  | Home security
 |  |  |  |  |  | TV license
 |  |  |  |  |  | Miscellaneous home
 |  |  |  |  |  | Home
 |  |  |  |  |  | Cable, internet, fax & land line office
 |  |  |  |  |  | Stationary
 |  |  |  |  |  | Printer/phone/fax
 |  |  |  |  |  | Computer accessories
 |  |  |  |  |  | Office furniture
 |  |  |  |  |  | Postage
 |  |  |  |  |  | Miscellaneous office
 |  |  |  |  |  | Office
 |  |  |  |  |  | Land line
 |  |  |  |  |  | Other
 |  |  |  |  |  | Miscellaneous abroad
 |  |  |  |  |  | Abroad
 |  |  |  |  |  | Groceries
 |  |  |  |  |  | Groceries - cash
 |  |  |  |  |  | Groceries abroad
 |  |  |  |  |  | Lunch/dinner/coffee - outside
 |  |  |  |  |  | Lunch/dinner/coffee - cash
 |  |  |  |  |  | Dry cleaning
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME] living
 |  |  |  |  |  | Daily living
 |  |  |  |  |  | Taxis
 |  |  |  |  |  | Public transportation
 |  |  |  |  |  | Car
 |  |  |  |  |  | Transportation
 |  |  |  |  |  | Dining out/drinks
 |  |  |  |  |  | Video/DVD
 |  |  |  |  |  | Movies/plays
 |  |  |  |  |  | Concerts/clubs
 |  |  |  |  |  | Miscellaneous Entertainment
 |  |  |  |  |  | Entertainment
 |  |  |  |  |  | Insurance
 |  |  |  |  |  | GP
 |  |  |  |  |  | Out patient treatment
 |  |  |  |  |  | Hospitalization
 |  |  |  |  |  | Prescriptions
 |  |  |  |  |  | Over-the-counter drugs
 |  |  |  |  |  | Dentist
 |  |  |  |  |  | Co-payments/out-of-pocket
 |  |  |  |  |  | Life insurance
 |  |  |  |  |  | Miscellaneous Health
 |  |  |  |  |  | Health
 |  |  |  |  |  | Plane fare
 |  |  |  |  |  | Accommodation
 |  |  |  |  |  | Food
 |  |  |  |  |  | Souvenirs
 |  |  |  |  |  | Transport
 |  |  |  |  |  | Miscellaneous vacations
 |  |  |  |  |  | Vacations
 |  |  |  |  |  | Presents
 |  |  |  |  |  | Red packets
 |  |  |  |  |  | Miscellaneous family/friends
 |  |  |  |  |  | Family/friends totals
 |  |  |  |  |  | Magazines
 |  |  |  |  |  | Newspapers
 |  |  |  |  |  | Charity
 |  |  |  |  |  | Dues/subscription
 |  |  |  |  |  | Cloths Her
 |  |  |  |  |  | Cloths repairs Her
 |  |  |  |  |  | Cloths Him
 |  |  |  |  |  | Cloths repairs Him
 |  |  |  |  |  | Haircuts
 |  |  |  |  |  | Facial
 |  |  |  |  |  | Massages
 |  |  |  |  |  | Toileteries
 |  |  |  |  |  | Durables/dressing
 |  |  |  |  |  | Long-term savings
 |  |  |  |  |  | Credit card payments
 |  |  |  |  |  | Income tax (additional)
 |  |  |  |  |  | Other obligations
 |  |  |  |  |  | Financial obligations
 |  |  |  |  |  | to be allocated
 |  |  |  |  |  | Other 1
 |  |  |  |  |  | Other 2
 |  |  |  |  |  | [NAME]. payments
 |  |  |  |  |  | Total expenses
 |  |  |  |  |  | Total ex vacations
 |  |  |  |  |  | Miscellaneous total
 |  |  |  |  |  | Saving