Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 44 of 50
Take your time. Find what helps.
SUMIF formula to total expenses by category in Excel
Use the SUMIF formula in Excel to total expenses by category: exact syntax, a category summary table, wildcards, the SUMIFS argument-order trap and a check total.
Read article
SUMIF not equal: total all expenses except one category
Total every expense except one category using SUMIF with the not-equal operator, then extend it to rent and EMI together to see everyday spending.
Read article
Why SUMIF returns 0 on your expenses (numbers stored as text)
SUMIF or SUM showing 0 on your expense sheet usually means numbers stored as text. Diagnose it, then fix it with VALUE, Text to Columns or multiply by 1.
Read article
SUMIF with wildcards to total spending at one merchant
Total everything you spent at one merchant from messy bank narrations using SUMIF with asterisk wildcards, plus the ? and ~ cases explained.
Read article
SUMIFS formula for monthly expenses in Excel (with examples)
Use SUMIFS in Excel to total expenses for each month: month-start cells, a less-than-next-month test, a 12-month table, EDATE and checks for text dates.
Read article
SUMIFS not matching dates: fix the date criteria in your sheet
SUMIFS returning 0 on date criteria? Check text dates, missing ampersand joins and dd/mm versus mm/dd, each with an ISNUMBER test and a fix.
Read article
SUMIFS with OR conditions: total several categories in one formula
SUMIFS only does AND. Here is how to total several categories at once in Excel or Google Sheets with SUMPRODUCT and SUMIFS, ISNUMBER and MATCH, or a group column.
Read article
Sum spending by payment mode (UPI, card, cash) with SUMIFS
Set up a payment-mode dropdown and a small SUMIFS table that shows UPI, credit card, debit card and cash totals for a month, each as a percentage.
Read article
SUMIFS with two criteria: category and month in Excel
Use SUMIFS in Excel to total one category in one month with a category dropdown and a month cell, then extend it to a grid of categories by month.
Read article
Summarise spend by currency with a pivot table
Build an Excel pivot table that shows foreign spend by currency in its own units next to INR totals, and avoid the grand total that adds rupees to dollars.
Read article
SUMPRODUCT to total expenses with multiple conditions
Use SUMPRODUCT to total expenses with several conditions, including OR logic and a MONTH test that SUMIFS cannot do, with correct Excel syntax.
Read article
SUMPRODUCT vs SUMIFS: which to use for expense totals
SUMPRODUCT or SUMIFS for expense totals? A side-by-side comparison on one sample sheet covering readability, text dates, speed and a simple decision rule.
Read article