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

#### Chopper50

##### New Member
 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))

### 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.

Replies
1
Views
55
Replies
0
Views
65
Replies
12
Views
100
Replies
13
Views
126
Replies
3
Views
66