Homework SourseProblem Formula Count Actual Hours Column Count of entires f
Problem
Formula
Count Actual Hours Column
Count of entires for Furst
Relational Operators
Total Actual Hours for the Loading Dock
= Equal to
Number of entries where the Estimate is 16 hours
<> Not equal to
Average Estimated Hours when more than zero
> Greater than
Total Estimated hours for Perez
< Less than
Total Actual Hours for Furst where the hours are more than 15
<= Less than or equal to
Total Actual Hours for Joyner before 1/1/2016
>= Greater than or equal to
Total Actual Hours for Joyner on the Loading Dock
Person
Date
Area
Estimated Hours
Actual Hours
Furst
12/23/15
North
0
0
Furst
12/16/15
West
14
16
Joyner
12/30/15
Loading Dock
0
0
Furst
12/11/15
Truck Repar
4
25
Furst
12/23/15
Loading Dock
8
13
Joyner
1/3/16
Truck Repar
4
4
Joyner
12/10/15
Loading Dock
0
17
Joyner
1/3/16
Truck Repar
12
4
Joyner
12/29/15
Truck Repar
4
10
Joyner
1/1/16
Loading Dock
6
12
Perez
12/19/15
West
16
16
Joyner
12/31/15
West
0
6
Perez
12/22/15
West
8
14
Perez
1/3/16
Loading Dock
8
16
Perez
12/16/15
Loading Dock
4
6
Hong
12/28/15
North
16
5
Hong
12/25/15
North
8
0
Hong
12/11/15
Loading Dock
0
31
Davis
1/7/16
West
16
2
Davis
12/16/15
West
24
24
Relational Operators
= Equal to
<> Not equal to
> Greater than
< Less than
<= Less than or equal to
>= Greater than or equal to
What are these 9 formulas for Excel? Can I have this by midnight? Please and thank you!
| Problem | Formula | ||||||
| Count Actual Hours Column | |||||||
| Count of entires for Furst | Relational Operators | ||||||
| Total Actual Hours for the Loading Dock | = Equal to | ||||||
| Number of entries where the Estimate is 16 hours | <> Not equal to | ||||||
| Average Estimated Hours when more than zero | > Greater than | ||||||
| Total Estimated hours for Perez | < Less than | ||||||
| Total Actual Hours for Furst where the hours are more than 15 | <= Less than or equal to | ||||||
| Total Actual Hours for Joyner before 1/1/2016 | >= Greater than or equal to | ||||||
| Total Actual Hours for Joyner on the Loading Dock |
Solution
1. =SUM(E2:E21) Considering person will be on column A; and person, date, area, eastimated hours etc. is in first row. You can change this formula accordingly.
2. =COUNTIF(A2:A21, \"Furst\")
3. =SUMIF(C2:C21, \"Loading Dock\", E2:E21)
4. =COUNTIF(D2:D21, \"16\")
5. AVERAGEIF(D2:D21, \">0\")
6. =SUMIF(A2:A21, \"Perez\", D2:D21)
7. =SUMIF(E2:E21, \">15\", E2:B21)
