Forum Discussion
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 ...
I've found it helpful to ask these "what's wrong" questions to chat GPT and see what it gives you. It's not always perfect, but it's an immediate response that you can try out.