'User defined function inside standard SUMIFS formula

I have written a function that checks cell to be crossed out:

Function isCrossedout(myRange As Range)
    isCrossedout = myRange.Font.Strikethrough
End Function

and I have a column "A:A" of numbers where I want to sum up crossed out elements only.

Can I insert in any cell the standard function SUMIFS with my user defined function? When I try this:

someCell.FormulaR1C1 = "=SUMIFS('Page'!RC1:RC1, isCrossedout)"

it returns zero value when the formula applied.

I realize there is a way to use summing such cells in a pure VBA way with a loop, but I want to try to use it with Excel SUMIFS formula.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source