countif-sumif-exercises student.xlsx

Use the attached “countif-sumif-exercises student.xlsx” workbook to complete this assignment. Your work should be done in this spreadsheet then submitted.
Note:
To answer the following questions, create formulas in the area below the data in the spreadsheet. You will need to determine whether to use SUMIF, COUNTIF, SUMIFS, or COUNTIFS for each question.
Tip:
Copy and paste the questions into the spreadsheet. Create the formulas to the right of each
You can use the following link as a reference guide
https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
_____________________________________________________________
Questions to answer in countif-sumif-exercises student.xlsx (attached)
How many Orders in orders in Boston :
number of microwave orders :
number of journeys with truck 3:
number of Peter White journeys:
how many times are no. of items less than 20:
sumif / sumifs sum of refrigerator items:
sum of washing machine items:
sum of items transported by truck 4:
sum of items transported by trucks:

countifs number of microwave orders in Boston :
number of Peter White journeys with truck 1:
number of orders in Boston after 2/3/2016:
number of orders between 2/3/2016 and 2/6/2016:
sumifs sum of microwaves transported to NY:
sum of items transported to Pittsburgh by truck 1:
sum of items ordered between 2/3/2016 and 2/6/2016:
sum of items transported to NY, Baltimore and Philadelphia:
Copy of countif-sumif-exercises student.xlsx

Last Completed Projects