On Time Delivery Percentage against the overall volume delivered

[Hari117]

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

[#2]

@Hari117 

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

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