#### craigexcel

##### Active Member

- Joined
- Jun 28, 2006

- Messages
- 291

- Office Version
- 2016

- Platform
- Windows

For example, if a cell formula is: =IF(A10=1,SUM(B10+C10),SUM(D10-E10))

how would I find the the 'start number' (taking the term used in the MID function) of the first "10" in the formula itself?

Also, is there a way to determine how many references there are to "10" in the formula, in this case --- 5?