Average Laptop Sales

=AVERAGEIF(B2:B5,"Laptop",C2:C5)

💼 9. Interview Tips

Q: When should you use SUMIF() instead of SUMIFS()?

Answer: Use SUMIF() when there is only one condition. Use SUMIFS() when multiple conditions need to be checked.

Q: What is the difference between COUNTIF() and COUNTIFS()?

Answer: COUNTIF() supports a single condition. COUNTIFS() supports multiple conditions.

Q: Where is SUMPRODUCT() commonly used?

Answer: Weighted averages, Revenue calculations, Inventory valuation, Financial models, Multi-condition calculations

🎯 Mini Practice Project

Create: Regional_Sales_Report.xlsx

Data: East Laptop 2 50000 100000, East Mobile 3 20000 60000, West Laptop 1 50000 50000, West Tablet 4 15000 60000

Tasks

✅ Total Sales in East

=SUMIF(A2:A5,"East",E2:E5)

✅ Total Laptop Sales

=SUMIF(B2:B5,"Laptop",E2:E5)

✅ Count Products Sold in West

=COUNTIF(A2:A5,"West")

✅ Average Sales in East

=AVERAGEIF(A2:A5,"East",E2:E5)

✅ Calculate Total Revenue Using Quantity × Price

=SUMPRODUCT(C2:C5,D2:D5)

📌 These are some of the most frequently used Excel functions in interviews and day-to-day business analysis.

Join our telegram channel: https://t.me/excel_data

➡️ Double Tap ❤️ For More