total number count

[ttowncorp]

how do i get a accurate count of a number that repeats in a cell that has text in it as well. for example below

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]data[/TD]
[TD]pizza#[/TD]
[TD]apple#[/TD]
[TD]oranges#[/TD]
[TD]grapes#[/TD]
[/TR]
[TR]
[TD]1234 pizza and wine[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3939 apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2345 oranges[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234 pizza and pie[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234 pizza and berries[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234 pizza[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3939 apples[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Re: Counting number with text

@ttowncorp
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).
I have merged both threads