=
FormulaCraft
Formulas
How-to
Fix errors
Pricing
Workspace
Auditor
Verify
Sign in
Get started
Formula workspace
Describe it, paste one to explain, or paste a broken one to fix.
Generate
Explain
Fix
Excel
Google Sheets
=SUM(IF(FREQUENCY(IF(B2:B7="Criteria", MATCH(A2:A7, A2:A7, 0)), ROW(A2:A7)-ROW(A2)+1)>0, 1))
.
⌘↵ to run
Generate formula
Workspace | FormulaCraft