20 formulas working on order data, with automatic checks, to copy and adapt.
Look up by code, sum by period, count working days, sum with two conditions and other everyday tasks. Each formula is shown working on sample order data, with a column that checks the result.
What you get
20 formulas on sample data
Lookup, sums, dates, text and ranges
Column that checks the result
Works in older Excel versions too
Product video (Portuguese narration)
Preview
Sample data used by the formulasThe 20 formulas checked in Excel
Who it's for
You use Excel in production, purchasing or quoting
You know the basics and want the next step
You train colleagues
Send us one drawing
We return a review with issues found, suggested fixes and a fixed-price scope. Free, under NDA if you need one.