I have cells A1, B1, and C1. The cells contain the values "100-BAS", "150-BAS", and"250-CHECK" respectively. I want to be able to sum the numberic porstion of the 3 strings. Ican make a mega forumula and add the contents of all three but using
"=VALUE(LEFT(A1,FIND("=",A1)-1))". How can I do this by utilizing an array?

If I do =SUM(VALUE(LEFT(A1:C1,FIND("=",A1:C1)-1))) and press CTRL+SHIFT+ENTER I get a #VALUE! error.

Thanks in advance!