Yes, there is a way to exclude cells with strikethrough lines from a formula. You can use the following formula:
- SUMIFS function: This function adds up the values in the range G22:G375 that meet certain criteria.
- Range: The range C22:C375 is used as the criteria range.
- Criteria: The criteria for the range C22:C375 is set to "<" which means that the cells in this range should not be blank.
- NOT function: This function returns the opposite of a logical value. In this case, it returns TRUE if the cell does not have a strikethrough line.
- FIND function: This function searches for a specific character or text within a cell. In this case, it searches for the strikethrough line character "¯" within the format of the cell.
- CELL function: This function returns information about the formatting, location, or contents of a cell.
Here's how this formula works:
Formula:
=SUMIFS(G22:G375,C22:C375,"<",NOT(FIND("¯",CELL("format",C22:C375)))0)
By combining these functions, the formula will only sum up the values in the range
G22:G375 if the corresponding cell in the range
C22:C375 is not blank and does not have a strikethrough line. This way, you can keep the formulas in
G22:G375 and still exclude certain cells from the calculation based on their formatting.