I want to SUM and COUNT Values between two text strings
Suppose in Row1, I have values like this
1,0,2,OUT,4,.,.,1,6,OUT,1,3
Now I want to SUM & COUNT Values Before, Between and After the Text "OUT"...
So,
For the SUM Function, the result should be
3 in the Cell A2, 11 in the Cell B2 and 4 in the Cell C2...
For the COUNT Function, the result should be
3 in the Cell A3, 5 in the Cell B3 and 2 in the Cell C3...
I'll be very thankful if you help me...
Suppose in Row1, I have values like this
1,0,2,OUT,4,.,.,1,6,OUT,1,3
Now I want to SUM & COUNT Values Before, Between and After the Text "OUT"...
So,
For the SUM Function, the result should be
3 in the Cell A2, 11 in the Cell B2 and 4 in the Cell C2...
For the COUNT Function, the result should be
3 in the Cell A3, 5 in the Cell B3 and 2 in the Cell C3...
I'll be very thankful if you help me...