asked on # summing the return on a filtered Xl column

hi,

I am using Xl 10. I have a worksheet with several thousand rows.

if I filter a column, rows only appear meeting the criteria.

however, when I try to sum a column which is filtered, I can not get an answer. the formula stops blank.

I notice the rows are a weird progression of numbers as many are skipped ( I would expect this) but how do I get totals for the columns

I am using Xl 10. I have a worksheet with several thousand rows.

if I filter a column, rows only appear meeting the criteria.

however, when I try to sum a column which is filtered, I can not get an answer. the formula stops blank.

I notice the rows are a weird progression of numbers as many are skipped ( I would expect this) but how do I get totals for the columns

Microsoft Excel

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a questionLog in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a questionGet an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

In the formula I posted the 9 tells Excel to sum, there are various other options, eg count (1), average(2) etc, you'll get a full list via Intellisense when you enter the formula, or you can find it in the Help files.

B:B is simply the range to sum which you would of course change to suit your needs.

B:B is simply the range to sum which you would of course change to suit your needs.

really i find the powers of XL a never ending tool that i need to constantly get more of.

your answer works... and explains what another has done...

=SUBTOTAL(9,D2:D3355) This expression was placed in the column of row 3356.

what i find fascinating and i would appreciate a comment on , is how this appears in all filtered results.

for instance if i am filtering on column B yet the row of this formula has no value in column B, the formulas' result is shown are still shown.

what is intellisense

your answer works... and explains what another has done...

=SUBTOTAL(9,D2:D3355) This expression was placed in the column of row 3356.

what i find fascinating and i would appreciate a comment on , is how this appears in all filtered results.

for instance if i am filtering on column B yet the row of this formula has no value in column B, the formulas' result is shown are still shown.

what is intellisense

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

.

also where would i place this formula