Suppose you have the following data. House Identifier Number of Rooms Selling Price Location 566602 8 345
Fantastic news! We've Found the answer you've been seeking!
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 | 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
Expert Answer:
The detailed answer for the above question is provided below SOLUTION To calculate the total numb... View the full answer
Related Book For 
Statistics Informed Decisions Using Data
ISBN: 9780134133539
5th Edition
Authors: Michael Sullivan III
Posted Date:
