Forum Discussion

areis1643's avatar
areis1643
Copper Contributor
Feb 28, 2024

what is the problem in this formula

=SUMPRODUCT(IF(ISNUMBER(FILTERXML("<t><s>" & TEXTJOIN("</s><s>", TRUE, H9:H100) & "</s></t>", "//s")), FILTERXML("<t><s>" & TEXTJOIN("</s><s>", TRUE, H9:H100) & "</s></t>", "//s"), 0))   thank you ...

Resources