Forum Discussion
Danger_SF
Jan 21, 2023Brass Contributor
Counting formulas on a separate tab based on filtering a column by the text in a cell
Good evening once again. I am using Office 365. Please see attached. I'm trying to do this: Depending on the text in USE:B2, filter SITES: B:B by that text, then count cells in SITES: P:P which a...
- Jan 22, 2023
=SUM(ISFORMULA(SITES!$P$3:$P$13)*(SITES!$B$3:$B$13=B2))
HansVogelaar
Jan 22, 2023MVP
=SUM(ISFORMULA(SITES!$P$3:$P$13)*(SITES!$B$3:$B$13=B2))
Danger_SF
Jan 22, 2023Brass Contributor
Thanks, as always, sir.