Re: Using AutoFilter In Excel, I can't get Excel to recalculate only .

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason Morin (jasonjmorin_at_OPPOSITEOFCOLDmail.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 13:15:20 -0800

You can perform basic sum and count calculations on
filtered data using the SUBTOTAL worksheet function. Look
under XL Help for instructions on how to use it.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Hi,
>
>I have created a spreadsheet with numbered values in
cells. At the top of
>the spreadsheet I have an area for calculations. Within
the spreadsheet I
>have several repeated lines of text with numbers tied to
them. I thought
>that when I filtered the spreadsheet for a certain
lineof text or name, the
>appropriate calculations would be performed only on/for
that line of text or
>name. This is not happening as Excel is making
calculations from the entire
>sheet. Is it possible to have Excel filter for a
certain line of text, there
>may be 200 entries or so and calculate only what is
being filtered. I can
>group these to avoid the problem, but then the
spreadsheet is added to daily
>with numerous other lines of text or names and that
would not be feasable. I
>need to filter for a certain line of text or name and
have Excel calculate
>only those values tied to it and not the entire sheet.
Is this possible?
>
>Thanks for any help in advance!!
>.
>

Relevant Pages

  • Excel 2003 filtering problems
    ... When autofiltering in Excel 2003 I have serveral columns of ... if I do not filter and scroll down through the spreadsheet ... missing from the original filtered drop down list. ...
    (microsoft.public.excel.worksheet.functions)
  • Macro in Excel causes problems when spreadsheet is opened in IE
    ... I am having problems with an Excel spreadsheet that has couple buttons ... The spreadsheet is a link on the website. ... The spreadsheet has two buttons - to filter and to remove filter. ... The problem is when the user closes the file and then opens it again, ...
    (microsoft.public.excel.programming)
  • Re: New rows not added to data filtering
    ... If you have Excel 2003 create a Data, ... When new data is added to the blank rows at the bottom, ... | bottom of the filtered list I get rows which do not fulfill the filter ... | The spreadsheet is used by others with limited Excel experience so I don't ...
    (microsoft.public.excel.misc)
  • Re: Growing Total using Autofilter in Excel?
    ... With headings in row 1, add this formula to cell C2, and copy down: ... I have a spreadsheet i am working on in Excel 2002. ... but when i use the filter i see the larger totals in the list (which i ...
    (microsoft.public.excel)
  • Re: Using AutoFilter In Excel, I cant get Excel to recalculate only .
    ... > I have created a spreadsheet with numbered values in cells. ... > the spreadsheet I have an area for calculations. ... Is it possible to have Excel filter for a certain line of text, ...
    (microsoft.public.excel.misc)