SUMIF not strikethrough

google-sheets google-drive-api sum strikethrough
Cybercampbell picture Cybercampbell · Sep 11, 2012 · Viewed 12.5k times · Source

Is is possible with Google Sheets to calculate the fields (currency) and ignore all fields that have had a strikethrough applied?

Answer

Henrique G. Abreu picture Henrique G. Abreu · Sep 11, 2012

Cell formatting can not be used as a criteria on spreadsheet formulas as there's no formulas (AFAIK) that can grab a cell formatting.

It would be much easier if you'd have another column where you marked your values with a cell value change, like 'yes/no' or an 'x'.

You can do it in Apps Script. But relying in formatting to make calculations in Apps Script is tricky. I recommend have a menu triggered function that grabs the "strikethrough" format and generate a 'yes/no' column so you can use in regular formulas like SumIf.

Related questions

How to automatically import data from uploaded CSV or XLS file into Google Sheets

I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a Google Drive folder. Currently, I am manually opening those files in Drive web interface and converting them to Google Sheets. …

Read More
Google Sheets: How to replace text in column header?

I have a query like this =QUERY(B2:C9; "select (C * 100 / B) - 100") in my Google Sheets. What is displayed as a column header is: difference(quotient(product(100.0()))100.0()). I want to put a human readable description there instead. How can …

Read More
How can I create a hyperlink in the middle of cell text?

In google spreadsheets, it is possible to add a hyperlink to a cell as: =hyperlink("www.google.com", "search the web") This will show the text search the web which will hyperlink to google. However, I am wondering: How can …

Read More