In Row 1 of this sheet I have formulas like
What am I doing wrong?
How can I change the formula such that the values in Row 1 from
F show the counts of non-empty cells in the main part of the table but only when the Importance value of that row is
P.S. If it's easier to demonstrate within an actual sheet, you can create a copy of my Google Sheet, edit your copy, change its permissions so that it's publicly-viewable and then share its URL here.