Summation of multiple values across several cells. Cell format [2/1/1] or [0.5/1/2]

Chopper50

New Member
Joined
Mar 14, 2013
Messages
22
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]
D3 / 3.754 / 38.2 / 34.5 / 33 / 2.75
E2.25 /1.75 /2 /2.5 /3.25 /
F0.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))
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,591
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top