SUMIF is not crossed out

Question

Is it possible with Google Sheets to calculate fields (currency) and ignore all fields that have crossed out text applied to?

Answer 1

Cell formatting cannot be used as a criterion for spreadsheet formulas because there are no formulas (AFAIK) that can capture cell formatting.

It would be much simpler if you had another column in which you marked your values ​​with the cell value changing, for example, yes / no or x.

You can do this in Script Applications . But relying on formatting for calculation in Script applications is difficult. I recommend having a function with a menu function that captures the strikethrough format and generates a yes / no column, so you can use it in regular formulas like SumIf .

Answer 2

The answer is here: http://igoogledrive.blogspot.ca/2012/09/user-defined-function-to-sum-all.html