In the attached spreadsheet (no macros) I have a filterable table where I what to get the number of VISIBLE instances where Column E may have an “X” AND the adjacent Column F is in Red Font. That total should appear in cell F2 (and should reflect the effects of applying any filters).
I’ve tried to modify several of the scores of formulas and macros I found on the internet but they all seem to want to APPLY conditional formatting to cells or simply count occurrence of a cell with some font color on some condition.
I am open to Formulas and/or Macros. Any help is appreciated.
Bookmarks