# 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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### 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
10
Views
512
Replies
4
Views
1K
Replies
3
Views
849
Replies
0
Views
466
Replies
5
Views
792

1,172,021
Messages
5,878,763
Members
433,370
Latest member
mcleven

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