Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count number of values between plus signs in addition calc
I'd like to count the number of values that a user enters in an excel simple
addition calculation. For example, if the cell has "=17+256", I'd like to get the count of "2". If the cell has "=101+2+0+65", I'd like to get the count of "4". Is there a way to parse this 'function' string? Everything I've tried so far starts *after* the cell value has been calculated (e.g. it's working with a single value of 273 and a single value of 168 for the two examples above, respectively). Thanks, - Cathy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
How to Count Rows with defined values in multiple columns | Excel Worksheet Functions | |||
Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |