I will create and fix google sheets formulas and spreadsheet errors
Data Analyst, Excel, SQL, Retail Analytics, Inventory Analytics
About this Gig
Need help with broken formulas or time-consuming calculations in Google Sheets?
I will create, fix and test formulas so your spreadsheet delivers clear, reliable results.
I can help with:
- IF, IFERROR, SUMIFS and COUNTIFS
- VLOOKUP, XLOOKUP and INDEX/MATCH
- FILTER, QUERY and ARRAYFORMULA
- Date, text and lookup calculations
- Dropdowns, data validation and conditional formatting
Packages:
BASIC Up to 3 simple formulas in one file, with testing and a brief explanation.
STANDARD Up to 7 formulas in one file, with data validation and usage notes.
PREMIUM Up to 15 formulas across tabs in one file, with validation, conditional formatting and a user guide.
You will receive an editable Google Sheets file with working formulas.
Each unique formula counts as one; copying it down multiple rows does not count as additional formulas. Revisions cover adjustments to the agreed requirements.
Apps Script, dashboards and external integrations are outside this gig's scope.
Please message me with a sample file and your expected result before ordering, especially for complex formulas or large existing spreadsheets.
Platform:
Google Sheets
Development technology:
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation

