SUMIFS and COUNTIFS
Use SUMIFS to total values that match multiple conditions, such as sales for a particular customer and month. Use COUNTIFS to count matching records.
XLOOKUP or INDEX-MATCH
Use these lookup functions to bring values from a master list into a working report. They are useful for mapping ledgers, customer names, rates and categories.
IFERROR and ROUND
Wrap a formula with IFERROR to show a clean result when a lookup has no match. Use ROUND to keep financial reports consistent.
Text and date cleanup
TRIM, LEFT, RIGHT, TEXT, MONTH and YEAR help clean imported data and organise reporting periods.
Next steps
Combine these formulas with PivotTables and data validation. For a reporting structure, read the Excel MIS report guide.