sum only numeric strings in a list containing both numeric and text strings

[monojchakrab]

I am working with a list as follows :

{"x", "100","200")

And I want to sum only the 100 and 200, skipping the text string [the text string is not at a fixed loaction in all the lists, so list.skip does not work).

Is there some combination of List.Sum and List.Transform to acheive this task?

Thanking in advance

[Vijay_A_Verma · Accepted solution]

See here

List.Sum(List.Transform({"x", "100","200", "x300", 500}, (x)=> if Value.FromText(x) is number then Value.FromText(x) else 0 ))

[monojchakrab]

Thanks @Vijay_A_Verma - that worked like a charm. I was missing using the function, which simplifies the code.