How to simply sum the 1st 12 rows of a filtered result?

I would like to find the simplest way to sum the 1st 12 rows of a filtered result.

The example here shows my list filtered for the "Gas" company. This results in a long list of several hundred rows.
But I only want to sum the first 12 rows (12 months).

But since the results of a filtered view is not a new table, Excel does not see the first 12 rows as Rows 1-12. Instead, it sees each row as the number it is in the unfiltered list.
So it's impossible to use the simple sum function to add up the 1st 12 rows of the result.

I really don't want to have to copy the data to a new tab just to add up 12 rows.... there must be an easier way!

Can someone enlighten me?

Thanks!!

How to sum 1st 12 rows of Subtotal.jpg

Since you want to filter the year 2023 why not use the filter ['end with' ...23] to get the 12 months?

The reason I can't use "end with" is that I'm not filtering by date. I'm filtering by the description column or payor (like the gas company).

I'm using the latest version of Excel that is included Office 365.

I have attached an example excel file with a simple table of colors and numbers.

It's easy to see the problem because if you set the filter to any color the result of a "SUM(C9:C21)" is always the same regardless of the filter results.

-Btmacdou

How to sum 1st 12 rows of Subtotal.xlsx

Another way,

Please Login or Register  to view this content.

Do you want just the top 12 by position or the 12 biggest values?