Thread: Identifying and adding elements in a cell range

Forum, I'm currently using the following code to count up the instances of VA within a group of cells on a worksheet and add them together. For instance, if I enter 8VA and 3VA, the calculation returns 11VA, which is perfect. However, it only grabs the first digit before the VA, so if I enter 11VA and 12VA, it returns 3VA instead of 23VA. How can it be mofidied to add double digits, too?

=SUMPRODUCT(--MID(Schedule!E4:CQ4&"0va",SEARCH("va",Schedule!E4:CQ4&"0va")-1,1))