Count occurences informula

[wilma2299]

I have a range of that contain formula. I would like to count the number of occurences of part of the formula in all the cells. Is this possible?

 

[schielrn]

Maybe Erik's formulas here can assist you:

http://www.mrexcel.com/forum/showthread.php?t=327546&page=2

Hope that helps.

 

[wilma2299]

I tried, but that didn't work. I'm trying to count the number of times part of a cell is referenced. i.e. g585 -> I want to count only 585

 

[schielrn]

Oh I understand now. If 585 is in a cell more than once do you want that counted as multiple occurences?

 

[wilma2299]

Yes, but I need it count the occurences in the formula in a cell that is in a range.