
#REF!, #VALUE!, #N/A and #DIV/0! errors
• Incorrect calculations and totals
• Broken cell references
• IF, SUMIF, COUNTIF and lookup formulas
• XLOOKUP, VLOOKUP and INDEX/MATCH problems
• Formula improvements and error handling
• General workbook troubleshooting
#REF!, #VALUE!, #N/A and #DIV/0! errors
• Incorrect calculations and totals
• Broken cell references
• IF, SUMIF, COUNTIF and lookup formulas
• XLOOKUP, VLOOKUP and INDEX/MATCH problems
• Formula improvements and error handling
• General workbook troubleshooting