Question: How to do a SUMIF function for Total Sales for orders less than $500? What is the formula needed? Category Price Per Unit Units Ordered
How to do a SUMIF function for "Total Sales for orders less than $500? What is the formula needed?
| Category | Price Per Unit | Units Ordered | Order Total | Delivery |
| Baseball | $144.99 | 6 | $700 | Free |
| Baseball | $199.99 | 4 | $800 | Free |
| Basketball | $6.99 | 34 | $300 | $ 250.00 |
| Basketball | $99.99 | 30 | $4000 | Free |
| Football | $5.15 | 15 | $78 | $ 250.00 |
| Basketball | $136.99 | 1 | $135 | $ 250.00 |
| Football | $2.85 | 52 | $1185 | $ 250.00 |
| Football | $6.24 | 25 | $1669 | $ 250.00 |
| Football | $2.85 | 125 | $52 | $ 250.00 |
| Football | $7.09 | 45 | $378 | $ 250.00 |
| Football | $1.33 | 822 | $23 | Free |
| Football | $4.82 | 15 | $22 | $ 250.00 |
| Football | $2.85 | 75 | $63 | $ 250.00 |
| Football | $1.01 | 38 | $38 | $ 250.00 |
| Football | $2.95 | 127 | $42 | $ 250.00 |
| Football | $3.10 | 22 | $690 | $ 250.00 |
| Baseball | $159.99 | 3 | $30 | Free |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help