Percentag of 4 different totals

  • Thread starter Thread starter Trish
  • Start date Start date
T

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?
 
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.
 
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,D1:D2)

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 "D1:D2" 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
 
Back
Top