Percentag of 4 different totals

[Trish]

I need to figure out the percentage of total shipments for
4 different delivery times during the day. Our delivery
times are 6:00am, 1:00pm, 3:00pm & 4:00pm. Does anyone
have a suggestion?

 

[Jim]

The general answer is to divide the smaller number by the larger.
Let's say you have 100 deliveries a day, of which 25 are at 1:00. Divide 25
by 100. This returns .25 or 25%

If you want the % sign, Format>Cell>Number tab>Percentage.

 

[one_idea]

Trish;

Here's what I did:

Entered the info in Cols A, B, and C.

Copied the text in B1 (Del time) to D1.

Typed 'Count' in E1.

At E2, entered this formula:
=DCOUNT(A1:C13,A1,D12)

Then, under the D column heading, type any of the
delivery times you want and press Enter; the number of
deliveries shows up. You can have four copies of the
formula in four different cells and change the "D12" in
the three remaining formulas to three other areas and
have it display all four times at once.

A B C D E
Del.# Del time Co. Del time Count
1 6:00 DHL 6:00 4
2 1:00 FedEx
3 3:00 UPS
4 4:00 DHL
5 6:00 DHL
6 6:00 FedEx
7 3:00 UPS
8 4:00 DHL
9 6:00 DHL
10 1:00 FedEx
11 1:00 UPS
12 4:00 DHL