Question: I just need the excel formula to answer questions like these; What is the total number of units ordered by all retailers between 1/1/2019 and

I just need the excel formula to answer questions like these;

What is the total number of units ordered by all retailers between 1/1/2019 and 6/30/2021?

What is the total dollar value of all orders placed by retailers between 1/1/2019 and 6/30/2021?

The info I have on my excel workbook is: Order date, Retailer, Brand, Product, Order size(units), Unit Price ($/unit).

I dont need the answer, hence the reason why I didn't provide the info but how would I solve, with the info listed above, using excel? What is the excel formula? Please and Thank you.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Ron Stotez established his business, Stotez Shoes, in 1985. Since then, he has run his business as a sole proprietor. Ron keeps records, and his wife helps him prepare basic accounting records. As...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Custom Fabric Ventures is a small company that produces fabric-based wardrobe accessories (such as, handbags, scarves, and headbands) and home accessories (such as placemats, pillows, and window...

Chapter 4Exercises 5, 8, 12, 17, and18 Problem 12 172 iStockphoto Variable Costing In 2012, the all-tube amplifier p r o d u ce d b y C l a u s e n Tu b e r e ce i ve d rave reviews and the company...

Excel Online Structured Activity: EOQ Please Post Excel formula to Calculation The annual requirement of a part is 310,200 units. The order cost is $140 per order, the holding rate is 14 percent and...

Create in Excel Form and answer questions? A hospital is analyzing its overhead costs. It is not clear whether the number of patient days or nursing hours would be the best cost driver to use in...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

In the early 1980s, planners were examining alternate sites for a new airport to serve London. In their economic analysis, they computed the value of the structures that would need to be removed from...

Greg has operated his shop for 2 years. He buys coffee from a local supplier and bakes the cinnamon rolls in-house. Your business consists of catering events and selling fine mixers. The plan is for...

The term negative amortization refers to the situation where unpuid interest is added to the principal balance. True False

Professor Borden proposes a new divide-and-conquer algorithm for computing minimum spanning trees, which goes as follows. Given a graph G = (V, E), partition the set V of vertices into two sets V 1...

Use Table F.9 to find the compressibility of R-410a at 140 F and (a) Saturated liquid, (b) Saturated vapor, and (c) 400 psia.

Tony Rich Inc. reported income from continuing operations before taxes during 2008 of $790,000. Additional transactions occurring in 2008 but not considered in the $790,000 are as follows. 1. The...

R-410a enters the evaporator (the cold heat exchanger) in an air-conditioner unit at 0 F, x = 28% and leaves at 0 F, x = 1. The COP of the refrigerator is 1.5 and the mass flow rate is 0.006 lbm/s....

The seismic instrument shown is attached to a structure which has a horizontal harmonic vibration at 3 Hz. The instrument has a mass m = 0.5 kg, a spring stiffness k = 20 N/m, and a viscous damping...

a door to door hearing aid salesman specifically targets elderly clients. when the clients ask questions about the contract, the salesman is not truthful with them entirely. the answers to their...

Describe what a one-minute self-sell is and what it contains.

Define the following 14 key terms throughout the chapter identified in bold with their definition in italic font. They are listed at the end of the chapter.

List and explain the steps in the negotiating process.