In cell K3, enter a formula using the COUNTIF function that counts the number of Expansion projects,
Fantastic news! We've Found the answer you've been seeking!
Question:
- In cell K3, enter a formula using the COUNTIF function that counts the number of Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J3.
Transcribed Image Text:
D E G M N 1964= Hempstead University Foundation 1 2 ID - Project Name - Project Type Campus Green Feature - Completed Budget - Final Cost Project Type Average Cost $148,737 $63,783 Number Total Cost 3 EX-4096 Didrikson Gymnasium 4 LA-5066 Wales Lake 5 RE-1751 $213,475 $225,631 $743,687 $510,261 Expansion La Croix 2016 Expansion 5 Landscape Materials $59,320 $60,600 Hempstead Hempstead 2016 Landscape 8 $89,754 $60,935 Ardmore House Renovation Materials 2017 $82,500 New Construction $4,292,507 $613,215 $118,311 $123,012 6 EX-4188 Transit Center Hempstead $62,750 $1,183,113 Expansion New construction Newburgh Stormwater 2017 Renovation 10 $369,037 7 NE-3027 Bixbury Apartments LA-5104 Hempsted Field 9 RE-1854 $689,430 $42,500 Green roof 2017 $700,225 Upgrade $42,850 $56,127 $200,326 Landscape Hempstead Newburgh 8 Stormwater 2017 Sullivan Library Renovation Green roof 2018 $55,750 Final Cost 10 RE-1890 Richardson Hall Renovation $195,640 Newburgh Newburgh Stormwater 2018 >100000 11 LA-5218 Freestone Plaza Landscape Stormwater 2018 $48,700 $48,850 Number of Projects: 16 12 EX-4209 Boyle Residences 13 NE-3153 Ambani International Center New construction Hempstead 14 RE-1904 Clarkson Laboratory Expansion Newburgh Materials 2018 $109,800 $110,456 Green roof 2019 $847,400 $889,325 Completed Renovation La Croix Stormwater 2019 $78,775 $79,349 2019 15 LA-5276 Alumni Center Landscape Hempstead Materials 2019 $78,300 $78,550 Number of Projects: 16 RE-1922 Founders House Solar panels $32,500 $32,500 Hempstead Hempstead Renovation 2019 17 RE-1957 18 RE-1961 Grounds and Ruilding $195,600 $199,800 $82 500 Nakamura Physics Renovation Materials 2019 Campus Renovation Newburah Stormwater 2019 Š78 500 Nowburah D E G M N 1964= Hempstead University Foundation 1 2 ID - Project Name - Project Type Campus Green Feature - Completed Budget - Final Cost Project Type Average Cost $148,737 $63,783 Number Total Cost 3 EX-4096 Didrikson Gymnasium 4 LA-5066 Wales Lake 5 RE-1751 $213,475 $225,631 $743,687 $510,261 Expansion La Croix 2016 Expansion 5 Landscape Materials $59,320 $60,600 Hempstead Hempstead 2016 Landscape 8 $89,754 $60,935 Ardmore House Renovation Materials 2017 $82,500 New Construction $4,292,507 $613,215 $118,311 $123,012 6 EX-4188 Transit Center Hempstead $62,750 $1,183,113 Expansion New construction Newburgh Stormwater 2017 Renovation 10 $369,037 7 NE-3027 Bixbury Apartments LA-5104 Hempsted Field 9 RE-1854 $689,430 $42,500 Green roof 2017 $700,225 Upgrade $42,850 $56,127 $200,326 Landscape Hempstead Newburgh 8 Stormwater 2017 Sullivan Library Renovation Green roof 2018 $55,750 Final Cost 10 RE-1890 Richardson Hall Renovation $195,640 Newburgh Newburgh Stormwater 2018 >100000 11 LA-5218 Freestone Plaza Landscape Stormwater 2018 $48,700 $48,850 Number of Projects: 16 12 EX-4209 Boyle Residences 13 NE-3153 Ambani International Center New construction Hempstead 14 RE-1904 Clarkson Laboratory Expansion Newburgh Materials 2018 $109,800 $110,456 Green roof 2019 $847,400 $889,325 Completed Renovation La Croix Stormwater 2019 $78,775 $79,349 2019 15 LA-5276 Alumni Center Landscape Hempstead Materials 2019 $78,300 $78,550 Number of Projects: 16 RE-1922 Founders House Solar panels $32,500 $32,500 Hempstead Hempstead Renovation 2019 17 RE-1957 18 RE-1961 Grounds and Ruilding $195,600 $199,800 $82 500 Nakamura Physics Renovation Materials 2019 Campus Renovation Newburah Stormwater 2019 Š78 500 Nowburah
Expert Answer:
Answer rating: 100% (QA)
Solution COUNTIF function counts the cells which are equal to a value in a given ... View the full answer
Related Book For
Data Structures and Algorithms in Python
ISBN: 978-1118290279
1st edition
Authors: Michael T. Goodrich , Roberto Tamassia, Michael H. Goldwasser
Posted Date:
Students also viewed these accounting questions
-
1. In cell E2, enter a formula using the HLOOKUP function to determine a staff member?s base salary (which is based on the number of years of service). a. Use a structured reference to look up the...
-
In cell O2, enter a formula using nested IF functions to calculate the maximum amount of 401(k) contributions that the company will match for an employee. The companys 401(k) matching plan is based...
-
Write a short Python function that counts the number of vowels in a given character string.
-
Record your responses on the spreadsheet template. 2014 February 1 - Brady and Manning decide to start up a partnership. Brady brings in $10 000 cash and equipment costing $60 000, with $17 000 in...
-
How do the criteria for determining whether a lease qualifies as a finance (capitalized) lease differ between IFRS and U.S. GAAP?
-
Smart Watch Company reported the following income statement data for a 2-year period. Smart uses a periodic inventory system. The inventories at January 1, 2021, and December 31, 2022, are correct....
-
Diane Harris, public accountant, is the auditor of Fine Deal Furniture, Inc. In the course of her audit for the year ended December 31,2001, she discovered that Fine Deal had serious going concern...
-
(Pension Expense, Journal Entries, Statement Presentation) Henning Company sponsors a defined benefit pension plan for its employees. The following data relate to the operation of the plan for the...
-
1) An index model regression applied to past monthly returns in J+D's Chili Parlor stock price produces the following estimates, which are believed to be stable over time: r j =. 2% + 1.3r m If the...
-
The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many...
-
A city is finalizing its financial statement and has one last fund to consider. An internal service fund for technology services. Where should that fund be presented on the government wide financial...
-
Identify the four primary layers in the functional view of OS X ? What is Darwin ? Identify Darwin's two basic layers ? Explain how OS/X thread manages memory ? What is QuickTime ? What does...
-
Swifty Itzek manufactures and sells homemade wine, and he wants to develop a standard cost per gallon. The following are required for production of a 50-gallon batch. 2,880 ounces of grape...
-
Explain the history of IBM's OS/2, Unix, the introduction of Linux and the comparison of the Mac OS to both. Please be clear, coherent, and lengthy in the explanation of each OS. What is their...
-
Give some of the differences in how Windows OS, Mac OS, and Linux OS work, how do these differences translate into the methods and technology used to secure these systems? The subject is OS-Based...
-
While tuning a piano, the tuner observes 5 beats per second when he sounds the second harmonic (512 Hz) of the middle C string along with the upper C string. What are the possible frequencies of the...
-
George and Weezy received $30,200 of Social Security benefits this year ($12,000 for George; $18,200 for Weezy). George also received $5,000 from WalMart where he works a greeter. What amount of th...
-
Suppose that a business sells 6-month subscriptions to its monthly magazine. On January 1, the company receives a total of $600 for 10 subscriptions. To record this transaction, the company debits...
-
Answer the previous question for the case when T is a proper binary tree with more than one node.
-
Implement a function that reverses a list of elements by pushing them onto a stack in one order, and writing them back to the list in reversed order.
-
The shuffle method, supported by the random module, takes a Python list and rearranges it so that every possible ordering is equally likely. Implement your own version of such a function. You may...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Calculate asset turnover, accounts receivable turnover, days sales in...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Calculate the current ratio, the acid-test miam ratio, the debt-to-equity...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Cash flow from mmm operations was \($645,590\) for 2008 and \($795,823\) for...
Study smarter with the SolutionInn App