Ravi Sir's Cards › Excel
Courier Management System in Excel (card 2 of 2)
Revision card 2 for Courier Management System in Excel: GST: =ROUND((G5+H5)*Setup!$B$5,2) gives ₹7.92; Shipments per account: =COUNTIF(Shipments!$C$5:$C$5000,A5) gives 7; Account total: =SUMIFS(Shipments!$J$5:$J$5000,Shipments!$C$5:$C$5000,A5) gives ₹960.52. Includes an example data table.
Read card text
What this card says
2 for Courier Management System in Excel: GST: =ROUND((G5+H5)*Setup!$B$5,2) gives ₹7.92
Shipments per account: =COUNTIF(Shipments!$C$5:$C$5000,A5) gives 7
Account total: =SUMIFS(Shipments!$J$5:$J$5000,Shipments!$C$5:$C$5000,A5) gives ₹960.52. Includes an
Example
data table
Learn this in the lesson: Courier Management System in Excel: Zone Rate Chart, Weight Slabs, Fuel Surcharge, Delivery Status and Dashboard