SD Card Recovery ----How to Recover Lost Files from SD Card?: Solution to Problem: Creating a formula based on cell font format

Friday, 23 September 2016

Solution to Problem: Creating a formula based on cell font format

Creating a formula based on cell font format

I am trying to build what I think is a very simple formula, but I can't seem to find the proper syntax to complete it.
I want to sum a column of numbers, IF the number does NOT have the "strikethrough" feature applied to the cell's font.
Thus when I "strikethrough"
a value in the column, it will be excluded from the calculated total at the bottom of the column.
Seems like it should be simple, but I can't figure out what the value is to evaluate the IF statement.

Solutions to the Problem Creating a formula based on cell font format

Download SmartPCFixer to Fix It (Free)

You are going to need to use a UDF (user defined function) to do that.
Press Alt+F11 from your worksheet (which will take you into the VB editor), click Insert/Module on the VB editor's menu bar, then copy/paste the following code into the code window that
opened up...
Function CountStrikethroughs(ParamArray Rng())
Dim R As Range, A As Variant
For Each A In Rng
    For Each R In A
      If R.Font.Strikethrough Then CountStrikethroughs = CountStrikethroughs + 1
    Next
Next
End Function
Now, go back to your worksheet and enter this formula...
=CountStrikethroughs(B3:F7,I6:K11)
where you would change the argument to the CountStrikethroughs function to the range (or ranges; comma separate the ranges if more than one) that you want to count the strikethroughs in.
Edit
=====
I just noticed you said to add the values if the "number does NOT have the 'strikethrough' feature"...
I gave you the code for if it did have that.
Here is the corrected code.
Function CountStrikethroughs(ParamArray Rng())
Dim R As Range, A As Variant
For Each A In Rng
    For Each R In A
      If Not R.Font.Strikethrough Then CountStrikethroughs = CountStrikethroughs + 1
    Next
Next
End Function

Because of this Creating a formula based on cell font format error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error Creating a formula based on cell font format can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve Creating a formula based on cell font format error or repair the corrupted and damaged Windows files, you will need a Creating a formula based on cell font format error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

Start the computer and log in as administrator
Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
On the new confirmation window that appears, click Next
Restart your computer after the restoration has been completed