In Google Sheets I have a table like this:
JOB TYPE STATUS Generate files Scheduled In Progress Update certs Manual Completed Copy files Scheduled Pending ... (hundreds of rows)
Rows are sorted by descending priority. I need to count the STATUS values of the top 20 “Scheduled” jobs:
Top 20 Scheduled Jobs: Completed: 2 In Progress: 4 Pending: 14
I can use FILTER to select all the “Scheduled” jobs, but how do I select the “top 20” rows from that result (meaning the first 20 rows after the filter has been applied)?