4 tutorials tagged “arrayformula”.
ARRAYFORMULA, MAP/LAMBDA or fill down in Google Sheets? A decision table and side-by-side formulas for row math, AND/OR per row, row totals, running totals and per-row SUMIFS.
Calculate age from a date of birth in Google Sheets with DATEDIF: whole years, years-months-days, age on a set date, next birthday, plus leap-day and month-end edge cases.
Build a dependent drop-down in Google Sheets that works on every row and keeps working when you insert rows or add items. One helper formula, no named ranges.
Why Google Sheets shows #REF! "Array result was not expanded because it would overwrite data", how to find the blocking cell, and 6 fixes with copy-ready formulas.