DEVBYTECLUE / FIELD NOTES
Field notes
Small, practical lessons for clearer spreadsheets. Start with a real range, understand the formula, and check the result.
Add only the rows that match: SUMIFS
Total completed Sales orders without sorting or deleting the other rows. The important detail is that every condition range lines up with the amount range.
Read the guide ↗Find the matching record, even in older Excel
Look up an order owner by ID. Choose a formula that the recipient can actually open, and decide what should happen when the ID is missing or duplicated.
Read the guide ↗From a screenshot to a formula you can place correctly
A screenshot shows values, but may hide the worksheet coordinates. Recognition and formula generation are two separate steps, with your review between them.
Read the guide ↗Repair the cause of a formula error
An error is evidence. Keep the original formula, error code and expected result so that a repair solves the problem rather than merely hiding it.
Read the guide ↗