I have a lot of columns on top of each other, like so:
I would like to find all of the cells in this range that begin with
1a, and then sum up whatever follows. So in this example, we find
1a20, so our result would be 10+20, or
The difficult thing is that after the
a, there could be one or two digits, and I would also like to expand it to work with two-digit numbers before the
a as well. So we could have:
I've tried experimenting with what I've learnt about
SEARCH, but while I have been able to (to some extent) detect which cells to select, cutting off the start of it, especially when the length of the end and the start can vary, left me with a jumble of stacked
IF statements and an nonfunctional formula.
Unfortunately, I cannot use macros and my school is only up to Excel 2013, but I hope this is still possible.