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.
<colgroup><col width="135" style="width:101pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="135" style="width:101pt"> </colgroup><tbody>
</tbody>
=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>