# Simple Sum & Divide Formula

#### Mikeeverest

##### Board Regular
I am trying to obtain a % total for:
F1/E1 (61/6)=91% easy enough. The numbers are time service related and represent do or die. the goal was reach 61 times out of 67 = 91%

now i am trying to calculate for a secondary goal. in the 6 (above) there is 1 (unit) that was outside the second goal.

My formula looks like this:
=sum(e1+f1-h1)/sum(e1,f1)

Does that seem right?
Is there a more efficient way to write the formula?

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### Yard

##### Well-known Member
Hi Mike, I'm lost. 61/6 does not =91%.

Do you mean 61/67=91% and that of the remaining 6 items there is 1 that you want to represent as a percentage. As a percentage of what?

If

F1=61
E1=67

then what is in H1 and what do you want to see as a result??

#### Mikeeverest

##### Board Regular
ok. sorry. its hard to do this all in writing

61 units were on time, 6 were late. overall thats 91%

in the late i need to measure the percent of the total 67 that was over another time threshold = 1 unit. that 1 unit is in the 67 already.

I was thinking the formula was to take the (61+6-1)/(61+6). I did that and it seems to work, just wondered if there was a cleaner way to do it

#### Yard

##### Well-known Member
OK, you haven't said what's in all of your cells so based on that your formula works and I would leave it that way!

You're really saying you want 66/67.

The addition and subtraction to get there just depends on the data you have in your cells. I wouldn't worry too much - it's unlikely to be a processor-intensive calculation

Replies
3
Views
209
Replies
1
Views
297
Replies
5
Views
224
Replies
7
Views
1K
Replies
4
Views
653

1,191,691
Messages
5,988,111
Members
440,126
Latest member
duque00

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