Question
Suppose you have the following data. House Identifier Number of Rooms Selling Price Location 566602 8 345 East Dandenong 819658 9 585 East Dandenong 670168
Suppose you have the following data.
| House Identifier | Number of Rooms | Selling Price | Location |
| 566602 | 8 | 345 | East Dandenong |
| 819658 | 9 | 585 | East Dandenong |
| 670168 | 10 | 643 | East Dandenong |
| 859088 | 9 | 655 | East Dandenong |
| 397137 | 9 | 670 | East Dandenong |
| 944462 | 11 | 710 | East Dandenong |
| 189349 | 12 | 824 | East Dandenong |
| 787518 | 12 | 870 | East Dandenong |
| 849681 | 12 | 934 | East Dandenong |
| 848245 | 13 | 988 | East Dandenong |
| 331189 | 6 | 199 | West Sunshine |
| 264751 | 6 | 233 | West Sunshine |
| 102400 | 6 | 258 | West Sunshine |
| 685647 | 7 | 280 | West Sunshine |
| 196442 | 7 | 325 | West Sunshine |
| 360239 | 8 | 355 | West Sunshine |
| 756348 | 10 | 379 | West Sunshine |
| 193385 | 10 | 432 | West Sunshine |
| 766744 | 9 | 567 | West Sunshine |
| 484073 | 14 | 677 | West Sunshine |
If you want to calculate the total number of houses which are more than $350,000 and more than 6 rooms, which Excel rule should you use?
a. SUMIF
b. SUMIFS
c. COUNTIF
d. COUNTIFS
e. None of the above
Step by Step Solution
3.45 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
The detailed answer for the above question is provided below SOLUTION To calculate the total numb...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Statistics Informed Decisions Using Data
Authors: Michael Sullivan III
5th Edition
978-0134135373, 134133536, 134135377, 978-0134133539
