A broken formula or a spreadsheet that refuses to add up can stall your whole day. Send me the file and I will find the problem, fix it, and hand back a workbook that calculates the way it should.
What I work on:
- Formula errors: #REF!, #DIV/0!, #N/A, #VALUE!, #NAME? and circular reference warnings
- VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIF/SUMIFS, COUNTIF, IF logic, text and date functions
- Pivot tables that show wrong totals or will not refresh
- Data cleaning: duplicates, inconsistent formats, numbers stored as text
- Google Sheets equivalents of the above
How it works: you send the file and tell me what the correct result should look like. I diagnose the cause, fix the formula or structure, then check the recalculated results before delivery. You get back the working file plus a short note explaining what was changed, so the same issue is easier to avoid next time.
This gig covers one agreed issue in one workbook. If your file needs broader work, message me first and we can scope it before you order.