Forum Discussion

Hari117's avatar
Hari117
Copper Contributor
Sep 22, 2024

On Time Delivery Percentage against the overall volume delivered

Hi,

 

I have 2 columns on time delivery and volume delivered.

 

Here i want On Time Delivery Percentage against the overall volume delivered

 

Please help

1 Reply

  • Hari117 

    =SUM(B2:B100)/SUM(A2:A100)

    Adjust the ranges as needed, and format the cell with the formula as a percentage.

Resources