Sumproduct/Countif formula shortening help

[lametodd]

Hello,

I'm trying to make a formula that checks whether a given cell contains content from the entirety of another cell for every cell in the column. I was able to do it with the following setup:


=SUMPRODUCT(COUNTIF(A1,{"*"&A1&"*";"*"&A2&"*";"*"&A3&"*"}))


Trouble is, there are 100 cells in the column, so the formula to make it check each cell from A1:A101 would be massive. Is there any way to shorten this so I can accomplish this goal without such a lengthy formula?

Thank you!

 

[Aladin Akyurek]

Care to post just what you have A1:A3 and to word what must be calculated for this sample?