Excel Analysis Formula Cheat Sheet
SUMIFS, COUNTIFS, FILTER, UNIQUE, SUMPRODUCT and percentage-change patterns.
Existence
=COUNTIF(range,key)>0Lookup
=XLOOKUP(key,lookup,return,"Missing")Multi-sum
=SUMIFS(sum,range1,c1,range2,c2)Clean
=TRIM(CLEAN(A2))Unique
=UNIQUE(A2:A500)Filter
=FILTER(A2:D500,D2:D500="Open")Use the pattern, then verify the result
Cheat sheets are reminders, not substitutes for checking keys, data types, duplicates and edge cases. Follow the linked learning material when a pattern is new to you.