counting function

[polshek]

I have a spreadsheet with a column (F) that is made up of the same formula dragged down. This column also has conditional formatting applied, such that it will strike out the formula response. I would like to count the number of times that the cells in the column are NOT struck through. Is this somehow possible?

Thank you in advance for your assistance.

 

[Richard Schollar]

I'm sorry I don't understand - your CF strikes thru (ie conditionally formats) your cells if they contain "100% SD Revised","100% DD", or "100% SD". So, for the formula I posted to return 0, that means every cell in the range F10:F56 must contain either "100% SD Revised" or "100% DD" or "100% SD". Is this not the case?

 

[polshek]

The cells in the f10:f56 contain a formula (=LOOKUP(2,1/(F13:CZ13="X"),$F$4:$CZ$4)) which results in one of 70 different answers that are in the cells F4 thorugh CZ4. three of the 70 answers, (cell H4, I4, J4) are "100% SD Revised","100% DD","100% SD". does that make sense?

For the purposes of the counting function only, I want column F to no longer act as a formula, but rather text only.