Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve this by using sumif function with excel to sum the number of profits from countries in Europe. 1075 L A B D E

image text in transcribedPlease solve this by using sumif function with excel to sum the number of profits from countries in Europe.

1075 L A B D E F G H K M N 1 Region Country Item Type Sales Channel Order Prio Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Reve Total Cost Total Profit 2 Sub-Sahar Chad Office Supplies Online 2011-01-27 292494523 2011-02-12 4484 651.21 524.96 2920026 2353921 566105 3 Europe Latvia Beverages Online C 2015-12-28 361825549 2016-01-23 47.45 31.79 51008.75 34174.25 16834.5 4 Middle Ea: Pakistan Vegetables Offline 2011-01-13 141515767 2011-02-01 6515 154.06 90.93 1003701 592409 411292 5 Sub-Sahar Democrati Household Online C 2012-09-11 500364005 2012-10-06 7683 668.27 502.54 5134318 3861015 1273304 6 Europe Czech Rep Beverages Online C 2015-10-27 127481591 2015-12-05 3491 47.45 31.79 165648 110978.9 54669.06 7 Sub-Sahar South Afri Beverages Offline . 2012-07-10 482292354 2012-08-21 9880 47.45 31.79 468806 314085.2 154720.8 8 Asia Laos Vegetables Online 2011-02-20 844532620 2011-03-20 4825 154.06 90.93 743339.5 438737.3 304602.3 9 Asia China Baby Food Online 2017-04-10 564251220 2017-05-12 3330 255.28 159.42 850082.4 530868.6 319213.8 10 Sub-Sahar Eritrea Meat Online L 2014-11-21 411809480 2015-01-10 2431 421.89 364.69 1025615 886561.4 139053.2 11 Central An Haiti Office Supplies Online C 2015-07-04 327881228 2015-07-20 6197 651.21 524.96 4035548 3253177 782371.3 12 Sub-Sahar Zambia Cereal Offline M 2016-07-26 773452794 2016-08-24 724 205.7 117.11 148926.8 84787.64 64139.16 13 Europe Bosnia ani Baby Food Offline M 2012-10-20 479823005 2012-11-15 9145 255.28 159.42 2334536 1457896 876639.7 14 Europe Germany Office Supplies Online C 2015-02-22 498603188 2015-02-27 6618 651.21 524.96 4309708 3474185 835522.5 15 Asia India Household Online C 2016-08-27 151717174 2016-09-02 5338 668.27 502.54 35672252682559 884666.7 16 Middle Ea: Algeria Clothes Offline 2011-06-21 181401288 2011-07-21 9527 109.28 35.84 1041111 341447.7 699662.9 17 Australia a Palau Snacks Offline L 2013-09-19 500204360 2013-10-04 441 152.58 97.44 67287.78 42971.04 24316.74 18 Central An Cuba Beverages Online H 2015-11-15 640987718 2015-11-30 1365 47.45 31.79 64769.25 43393.35 21375.9 19 Europe Vatican Cit Beverages Online 2015-04-06 206925189 2015-04-27 2617 47.45 31.79 124176.7 83194.43 40982.22 20 Middle E 2010 n 10 L Doreenalcare Offline 201001 271502107 65A 017 67 1020 2700 1 GA01 77

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Services Sales Handbook A Professionals Guide To Becoming A Top Producer

Authors: Clifton T. Warren

1st Edition

1631574930, 978-1631574931

More Books

Students also viewed these Finance questions

Question

Define group. What are the different types of groups?

Answered: 1 week ago