Scribd
Upload
21 views2 pages

Delivery Summary of Appliances by Driver

The document appears to be a log of delivery orders listing the order number, date, driver's name, item delivered, and number of items. It includes 24 orders ranging from order 100001 on 2/1/2013 to order 100024 on 2/9/2013. The orders were for TVs, washing machines, refrigerators, and microwaves delivered by drivers John May, Peter White, Carl Nowak, and George Ramsay.

Uploaded by

Shubham Bhardwaj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views2 pages

Delivery Summary of Appliances by Driver

The document appears to be a log of delivery orders listing the order number, date, driver's name, item delivered, and number of items. It includes 24 orders ranging from order 100001 on 2/1/2013 to order 100024 on 2/9/2013. The orders were for TVs, washing machines, refrigerators, and microwaves delivered by drivers John May, Peter White, Carl Nowak, and George Ramsay.

Uploaded by

Shubham Bhardwaj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Order no.

Date Driver's name Item Number of items


100001 2/1/2013 John May TV 25
100002 2/1/2013 Peter White washing machine 30
100003 2/2/2013 Carl Nowak washing machine 15
100004 2/3/2013 Peter White TV 32
100005 2/3/2013 George Ramsay refrigerator 25
100006 2/3/2013 Carl Nowak washing machine 18
100007 2/3/2013 John May refrigerator 15
100008 2/4/2013 Carl Nowak refrigerator 25
100009 2/4/2013 Peter White TV 30
100010 2/4/2013 George Ramsay refrigerator 15
100011 2/4/2013 Mertl Pavel microwave 25
100012 2/4/2013 John May washing machine 14
100013 2/5/2013 John May washing machine 25
100014 2/5/2013 Carl Nowak TV 30
100015 2/5/2013 George Ramsay microwave 15
100016 2/5/2013 Peter White TV 15
100017 2/6/2013 John May microwave 25
100018 2/7/2013 John May TV 30
100019 2/8/2013 George Ramsay washing machine 13
100020 2/8/2013 Peter White refrigerator 25
100021 2/8/2013 Carl Nowak microwave 30
100022 2/8/2013 Peter White washing machine 15
100023 2/8/2013 John May microwave 25
100024 2/9/2013 George Ramsay washing machine 34

sumif / sumifs
sum of refrigerator items: 105
sum of washing machine items: 164
sum of items transported by truck 4: 156
sum of items transported by trucks: 511
sum of items of John May in NY 39
sum of items of Peter White in Pittsburgh 45
Transport Destination
truck 4 Boston
truck 3 NY
truck 3 Philadelphia
truck 4 NY
truck 3 Boston
truck 1 Baltimore
truck 2 Philadelphia
truck 3 Baltimore
truck 1 Pittsburgh
truck 2 NY
truck 3 Philadelphia
truck 4 NY
airplane Baltimore
truck 4 Philadelphia
truck 3 Boston
truck 1 Pittsburgh
truck 1 NY
truck 4 Philadelphia
truck 3 Baltimore
truck 2 Philadelphia
truck 1 Pittsburgh
airplane NY
truck 4 Boston
truck 3 Baltimore

You might also like