Is there a formula to count how many times multiplication is used in cell?

Question

I have in Google Sheets (or Excel) a cell with a content =2*34+3*39

I need to sum up all the numbers used before the multiplication, in this example it would be 5 (2+3).

Is there any formula in Google Sheets or Excel to do this work?

There are hundreds of different formulas, but I can't find any suitable.

@player0 I see 2 also, but co-incidentally (and I'm not saying that this is mathematically sound) 2+3 = 5. — Tedinoz, Nov 10 '19 at 10:39
Sorry, Indeed it was impossible to understand what I wanted, I made it now hopefully more clearer. — user2866846, Nov 10 '19 at 13:33

user11982798 · Answer 1 · 2019-11-18T01:37:23.557

0

This will take an assumption, that the formula only use + for each mulification:

=sum(query(arrayformula(split(transpose(split(REGEXREPLACE(FORMULATEXT(A38), "=", ""), "+")), "*")), "select Col1"))

And this with an assumption, that the formula use + and each has multification:

=sum(arrayformula(value(regexextract(transpose(split(REGEXREPLACE(FORMULATEXT(A38), "=", ""), "+")), "^(.*)[*]"))))

edited Nov 18 '19 at 01:37

answered Nov 18 '19 at 01:06

user11982798

player0 · Answer 2 · 2019-11-12T19:17:27.353

-1

sure:

=LEN(REGEXREPLACE(FORMULATEXT(A1); "[^*]"; ))

=ARRAYFORMULA(SUM(1*IFERROR(REGEXEXTRACT(SPLIT(REGEXREPLACE(
 FORMULATEXT(A1); "(\*)"; "$1♥"); "♥"); "(\d+)\*"); 0)))

edited Nov 12 '19 at 19:17

answered Nov 10 '19 at 10:40

player0

2 Answers2