I will fix complex google sheets or excel formulas, xlookup, sumifs, and errors
Data Entry and Visualization
About this Gig
Getting frustrated with #N/A, #VALUE!, #REF!, or broken formulas in your spreadsheet? Or your calculation gives the wrong total because of messy raw data?
Hi! I am Arif, an Operations & Workforce Management (WFM) Analyst. I deal with thousands of rows of operational data daily, and I can quickly diagnose, fix, and automate your Google Sheets or Microsoft Excel formulas so you don't have to waste hours troubleshooting.
What I can fix and build for you:
- Lookup & Reference: VLOOKUP, XLOOKUP, INDEX MATCH, IMPORTRANGE
- Conditional Logic: Nested IF, IFS, IFERROR, AND/OR logic
- Math & Aggregations: SUMIFS, COUNTIFS, AVERAGEIFS, Weighted Averages (SUMPRODUCT)
- Dynamic Arrays (Google Sheets): QUERY, FILTER, UNIQUE, SORT, ARRAYFORMULA
- Data Cleaning: Removing duplicates, splitting text, fixing date/number formatting issues
- Mistake-Proofing: Dependent dropdown lists (Data Validation) & Conditional Formatting (auto-highlight errors/targets)
Why work with me?
- Accurate Business Logic: I don't just make the error disappearI ensure the math actually makes sense for your operations (e.g., proper weighted SLA vs. simple average).
- Clean & Documented: I will explain exactly why y
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Forms
•
Formulas
•
Macros
•
Cleaning
FAQ
Do you write complex VBA Macros or Google Apps Script?
This gig focuses purely on native Excel and Google Sheets formulas, functions, data validation, and conditional formatting. I avoid heavy scripts when native formulas can solve the problem faster and more reliably without breaking.
How do I share my Google Sheet or Excel file with you?
For Excel, you can attach the .xlsx file directly in our Fiverr chat. For Google Sheets, you can download it as an Excel file or share a "Viewer/Editor" link directly inside the Fiverr order page

