I will fix complex google sheets or excel formulas, xlookup, sumifs, and errors

Indonesia

I speak Indonesian, English

Data Entry and Visualization

Are messy spreadsheets slowing your team down? I help business owners, agency leads, and e-commerce operators build fast, error-free, and automated Google Sheets and Excel systems. From custom operati...
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