Excel Formula to count arguments in a sum

Question

I've been given a spreadsheet with a series of values in a column, made from summing individual numbers. e.g. =1+2+3

I'm looking for a way to count the number of numbers that have been summed (i.e. 3)?

But I can't seem to find any Excel formulas which will run on other formulas. Anything like LEN just runs on the result, not the formula.

Thanks.

barry houdini · Accepted Answer · 2017-12-02 10:32:15Z

1

If the formulas are like your example then you can use FORMULATEXT function like this

=LEN(FORMULATEXT(A2))-LEN(SUBSTITUTE(FORMULATEXT(A2),"+",""))+1

That counts the number of "+"s in your formula and adds 1 which should be the count of numbers added

FORMULATEXT function is available in Excel 2013 and later versions

answered Dec 2, 2017 at 10:25

barry houdini

46.9k8 gold badges67 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1