5wprl

Fix SUMIFS returning zero when matches exist. Criteria range size mismatch, text-vs-number traps, and the 8-character trick that catches hidden whitespace.

Resolve the green triangle ‘omits adjacent cells’ warning in Excel. When to fix, when to ignore, and how to suppress it for legitimate cases.

Fix broken dependent dropdowns in Excel data validation. INDIRECT failures, named range traps, and the dynamic array pattern that replaces them in Excel 365.

Resolve #VALUE! errors when subtracting times in Excel. The midnight-crossing trap, text-time conversion, and the [h]:mm format that handles 24+ hours.

Fix Excel IF statements stuck returning the false branch. Type comparison traps, the EXACT trick, and the hidden Boolean coercion that ruins logic.

Fix #REF! errors in Excel external workbook links. Path changes, OneDrive sync, and the Edit Links dialog procedure that survives file moves.

Fix ‘too many arguments’ errors in nested IF formulas. The 64-level limit, IFS replacement, SWITCH alternative, and the VLOOKUP-table pattern.

Fix #VALUE! errors in array-based lookups: INDEX/MATCH, INDEX with arrays, SUMPRODUCT lookups, and the Ctrl+Shift+Enter trick legacy Excel still needs.

Fix ‘text stored as number’ green-triangle warnings in Excel. Why SUM returns wrong totals, the bulk-conversion procedure, and import-time prevention.

Fix Google Sheets ImportRange stuck on ‘Loading…’. Quota exhaustion, authorization loops, the empty-cell trick, and the IMPORTRANGE-cache mystery.