I think I somewhat understand what you are looking for...
You seem to want to find the first cell in column E that contains the string "sub". Then you either want to start there or end there, in order to perform your summation.
What I don't know is what is in column A that you are counting, and why is your sum range different than your count range in the SUMIF() function and why is the column A range in the SUMIF different than that in the COUNTIF. These don't make sense.
Can you elaborate?
Bookmarks