Problem Formula Count Actual Hours Column Count of entires for Furst Relational
ID: 3783940 • Letter: P
Question
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
Explanation / Answer
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)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.