# Summary Breakdown

#### Stephen_IV

##### Well-known Member
What I am trying to do is give a summary of History, Music, PE and Science. On the table below is the value that I am looking for. the problem comes in when some of the classes are split i.e. Science/History. If the subjects are split they get divided in half. So if we have 3 hours science would get 1.5 and History would get 1.5. The reason we have a format as below is because my boss mandated it. Although I tried to steer him in a different direction but to no avail. So now I am stuch trying to figure out a summary of the table below. Could someone please help me? Someone supplied me with this formula I would like to thank them.
{=SUM(IF(ISNUMBER(SEARCH("-",E2:E8)),SUBSTITUTE(E2:E8,"-"," "),IF(ISNUMBER(SEARCH("/",E2:E8)),"0 "&E2:E8,E2:E8))+0)}.
Test Dreakdown.xls
ABCDEFG
1DateDayWorkDept.
28/19/2006Saturday
38/20/2006Sunday
48/21/2006Monday x3Science/History
58/22/2006Tuesday y3PE
68/23/2006Wednesday c2Science
78/24/2006Thursday e2Music
88/25/2006Friday t1-1/2Science11.5
98/26/2006Saturday r
108/27/2006Sunday
118/28/2006Monday w1-1/2Science
128/29/2006Tuesday a2Science/History
138/30/2006Wednesday d3Science
148/31/2006Thursday f3Science
159/1/2006Friday g1-1/2History11
169/2/2006Saturday
179/3/2006Sunday
189/4/2006Monday
199/5/2006Tuesday z2PE/Music
209/6/2006Wednesday z2-1/2PE
219/7/2006Thursday t2-1/2History/Science
Sheet1

What I am looking for is just the sum!
History------- 5-3/4
Music---------- 3
PE------------ 5-1/2

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### Stephen_IV

##### Well-known Member
the bottom should look like this.
Test Dreakdown.xls
JKLMNOPQRS
3Total
4History1-1/211-1/21-3/45-3/4
5Music213
6PE311-1/25-1/2
7Science1-1/221-1/21-1/21331-3/415-1/4
Sheet1

Replies
3
Views
118
Replies
0
Views
208
Replies
5
Views
564
Replies
4
Views
602
Replies
12
Views
535

1,136,652
Messages
5,677,008
Members
419,668
Latest member
DharmaK

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back