I changed the formula, of which I am obviously too ignorant to write LOL, to this:

=SUM(IFERROR(SUMPRODUCT(((LEN(B1)-LEN(SUBSTITUTE(B1,B1:$B$7290,"")))/LEN($B$1:$B$7290))),"")-SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$B$7290,$B1))))


and the first cell looks like it is counting correctly, showing '0'. But when I copy it down, I receive the #VALUE! error.

I'm not sure what you mean about 'size range' please forgive my ignorance!

The sheet has 2 columns (the first is of no consequence, as it is just an ID field, I should have removed it in my example I can see that now... but I need it once I correct the comments so I can run a mass update, so it can just be omitted from the formula) and 7290 rows, what other 'size range' info should I add?

Thanks again! I will definitely be able to apply this formula in the future once I get past the learning curve of editing it.