★0 XP
Question 1 of 10
The SUMIF function returns the sum of numbers which meet a certain criteria. To find the total value of all properties which cost less than $500,000 type =SUMIF(C2:C7, "<500")
Notice that the comparison operator needs to be inside quotes.
Notice that the comparison operator needs to be inside quotes.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Address | City | Value (thousands) | Units |
| 2 | 123 Balboa Ave | San Diego | 400 | 1 |
| 3 | 999 Main St | San Francisco | 600 | 2 |
| 4 | 456 Ave A | Los Angeles | 450 | 1 |
| 5 | 555 La Jolla Blvd | San Diego | 650 | 4 |
| 6 | 999 Ave E | Los Angeles | 350 | 3 |
| 7 | 111 Ave A | Los Angeles | 400 | 2 |
F1fx