A | [1/0.75/0] Or [1.75/0.5/0] | [1/0.5/0] Or [1/0.5/0] | [1/0.5/0] Or [1/1/0.33] | [2.5/1/0.33] Or [1/1/0.33] | [1/1.75/0.33] Or [1/1/0.33] |
B | [1/0.5/0] Or [1/0.5/0] | [1/0.25/0] Or [1/0.5/0] | [6.2/0.5/0] Or [1/0.5/0] | [1/0.5/0] Or [1/0.5/0] | [1/0.5/0] Or [1/0.5/0] |
C | [1/1/0.33] Or [1/1/0.33] | [2/1/0.33] Or [1/1/0.33] | [1/1/0.33] Or [1/1/0.33] | [1/1/0.33] Or [1/1/0.33] | [1/1/0.33] Or [.75/1/0.33] |
D | 3 / 3.75 | 4 / 3 | 8.2 / 3 | 4.5 / 3 | 3 / 2.75 |
E | 2.25 / | 1.75 / | 2 / | 2.5 / | 3.25 / |
F | 0.33 / | 0.33 / | 0.33 / | 0.66 / | 0.66 / |
<tbody>
</tbody>
The 3 in row D is the summation of the 1st 1's. The 3.75 in Cell D1 is the summation of the 1.75 from A1, 1 from B1, and 1 from C1.
I have Row D working with Mid and Find equations.
The 2.25 in Row E is the summation of 0.75 A1, 0.5 B1, and 1 C1. I have these numbers also using the Mid and Find. Getting the back side of Rows E and F is the issue I have. Is there an easier way than using the Mid and Find?
I'm open to using VB if need be, but I can't figure out how to do that either.
Here is an example of what my formula looks like in 1 cell:
=MID(B11,2,FIND("/",B11)-2)+MID(B15,2,FIND("/",B15)-2)+MID(B19,2,FIND("/",B19)-2)+MID(B23,2,FIND("/",B23)-2)+MID(B27,2,FIND("/",B27)-2)+MID(B31,2,FIND("/",B31)-2)+MID(B35,2,FIND("/",B35)-2)+IF(B36>3,2,1)&" / " & (MID(B11,FIND("r",B11,1)+3,(FIND("/",B11,FIND("r",B11))-1)-FIND("[",B11,FIND("r",B11)+1)) +MID(B15,FIND("r",B15,1)+3,(FIND("/",B15,FIND("r",B15))-1)-FIND("[",B15,FIND("r",B15)+1)) +MID(B19,FIND("r",B19,1)+3,(FIND("/",B19,FIND("r",B19))-1)-FIND("[",B19,FIND("r",B19)+1))+MID(B23,FIND("r",B23,1)+3,(FIND("/",B23,FIND("r",B23))-1)-FIND("[",B23,FIND("r",B23)+1))+MID(B27,FIND("r",B27,1)+3,(FIND("/",B27,FIND("r",B27))-1)-FIND("[",B27,FIND("r",B27)+1))+MID(B31,FIND("r",B31,1)+3,(FIND("/",B31,FIND("r",B31))-1)-FIND("[",B31,FIND("r",B31)+1))+MID(B35,FIND("r",B35,1)+3,(FIND("/",B35,FIND("r",B35))-1)-FIND("[",B35,FIND("r",B35)+1))+IF(B36>3,2,1))