I want to convert the below count & if function into a user defined function. However, its outcome is false. What's wrong with it? Can someone helps?? Thanks in advance!
![]()
Public Function TestFunction() Result = Selection.FormulaArray = _ "=COUNT(IF(Data!R2C3:R9999C3>R1C,IF(IF(Data!R2C1:R9999C1>R[-1]C1,Data!R2C1:R9999C1)<=RC1,Data!R2C3:R9999C3)))" TestFunction = Result End Function
Bookmarks