Excel FILTER Formula Explained Step-by-Step (Average, Count, Sum)
In this video, I will show you how to use the Excel FILTER function with a real-world example.
We will solve the following questions step by step:
1. What is the average rating of Fiction books sold in 2010?
2. How many Fiction books were sold in 2010?
3. What is the total price of Fiction books sold in 2010?
Using the FILTER function, we will dynamically extract data based on conditions and apply formulas like AVERAGE and SUM.
This tutorial is perfect for beginners and anyone who wants to learn how to analyze data quickly in Excel.
Formulas used in this video:
=AVERAGE(FILTER(F3:F514,(I3:I514=2010)*(J3:J514="Fiction"),"Not Found"))
=SUM(FILTER(F3:F514,(I3:I514=2010)*(J3:J514="Fiction"),"Not Found"))
=SUM(FILTER(H3:H514,(I3:I514=2010)*(J3:J514="Fiction"),"Not Found"))
Topics covered:
Excel FILTER function explained
Using multiple conditions in FILTER
Real-world data analysis in Excel
Combining FILTER with AVERAGE and SUM
If you found this video helpful, don’t forget to like, share, and subscribe for more Excel tutorials.
#Excel #FilterFunction #ExcelTutorial #DataAnalysis #ExcelTips