How to apply "strikethrough" as criteria for countif?

[pthor14]

I have a long list that gets updated often. I need to count up multiple recurring items in the list. I need to be able to ignore hidden rows like "subtotal" or "aggregate" can, but I also need to be able to ignore cells with a strikethrough over the text.

I've seen VBA code that will count the strikethroughs for me, but this is not what I need. I need the ability to make "strikethrough" or "No-strikethrough" be a criteria for a function like "countif" or "countifs".

[6StringJazzer]

COUNTIF and COUNTIFS do not have any option to consider formatting, and neither does any other built-in Excel function. You have to use VBA.

[pthor14]

Is there a way to adjust the code for the function? Or would I need to write my own countif type function to include it?

[pthor14]

So, I may have solved part of my problem.
I found some VBA code that would allow me to count strikethroughs in a list, so if I create another column where each cell results with either "Complete" or "incomplete" corresponding to whether the item in that row (from my original list) has a strikethrough or not, then I can use "Countifs" with multiple criteria including the column of Complete's or Incompletes.

But now, by using "COUNTIFS", I am unable to ignore hidden rows. Any thoughts on solution there?

[pthor14]

"exceljet.net/formula/count-visible-rows-only-with-criteria"

I found a link that appears to give a possible solution, but I can't figure out how to be able to apply multiple criteria from multiple ranges here the same way that COUNTIFS allows.

I am unable to post the link apparently because I'm new, but the gist is this:

=SUMPRODUCT((range=criteria)*(SUBTOTAL(3,OFFSET(range,rows,0,1))))

[pthor14]

I have figured out a solution that will work for me.

I used a COUNTIFS function with multiple criteria from multiple ranges. In one column, I had my main list. In another column I used a VBA function to state "complete" if the corresponding item in the list was crossed out. In a 3rd column I used another VBA function to determine row height, and if its height was not 0, then it would output "visible". Based on using those columns, the COUNTIFS function worked just fine.