Extracting numbers from text in Excel for Age ranges and summing

[EVPZ17]

Hello All, I would greatly appreciate if anyone could help me with this problem. I'm trying to take numbers entered into a list of age ranges in each cell on a spreadsheet and then add those numbers of each age range. For example below and what I've already tried that didn't work:

=MID($C$2:$C$250,ROW(INDIRECT("1:" &LEN($C$2:$C$250))), 1) and I also tried below:
=RIGHT($C$2:$C$250, LEN($C$2:$C$250)*MIN(FIND({0,1,2,3,4,5,6,7,8,9} $C$2:$C$250,&"0,1,2,3,4,5,6,7,8,9"})+1)

Below is what is an example of what is in each cell and I want to take each age range and then add the numbers for each age range.

0-3 years old: 4-7 years old: 8-11 years old: 12-15 years old: 1 16-19 years old: 20 years old and over:

<colgroup><col width="135" style="width:101pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="135" style="width:101pt"> </colgroup><tbody>
</tbody>

 

[EVPZ17]

Re: Extracting numbers from text in Excell for Age ranges and summing

I get a zero if I try a SUMIF function. I set up so it will sum up each age range in a seperate column. But I just keep getting errors or 0s. Here is the setup and formula:

0-3 years old: 4-7 years old: 8-11 years old: 12-15 years old: 16-19 years old: 20 years old and over: Here are the extra columns I created to attempt to take the values for each age range in each cell and Sum them into the seperate columns Age Ranges Count By Age 0-3 years old: 0 4-7 years old: 0 <tbody> </tbody>

<tbody>
</tbody>

The formula below is my attempt to get the sum for the first age range from cells A2 to A250
=SUMIF($C$2:$C$250, RIGHT(ISNUMBER, $C$2:$C$250("0-3 years old:")))