Скачать или смотреть How to Sum first N matching values in Excel - SUM first N matching records based on criteria

In this video, I'll show you how to Sum first N matching values in Excel in other words, how to SUM first N matching records based on criteria.

🎓 LEARN MORE in my Excel tutorials: https://exceldashboardschool.com/

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

🎁 SHARE this video and spread the Excel love.

Or if you are in a hurry, please click the 👍

First, we will extract records where the Department is Finance. This is done with the FILTER function like this. The first argument is the array that contains values, in this case, select the entire table. The second argument is the include, you can define the criteria here. The Department's names in Column B should be equal to finance.

Now we have to extract just the first 3 values from the array returned by the FILTER function. Type TAKE, then add the first argument, the filtered data set.
In the second argument, we'll dynamically determine the number of elements to extract based on user input, which will be provided in cell G3.
Press Enter the get the result. Finally, sum up the filtered records.

00:00 Intro
00:06 How to SUM first N matching values in Excel

#exceltips #excel #exceltutorial