Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sheryl
 
Posts: n/a
Default Using AutoFilter In Excel, I can't get Excel to recalculate only .

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!!
  #2   Report Post  
Jack Sheet
 
Posts: n/a
Default

Not sure if I completely understand the question, but have you tried using
=SUBTOTAL() instead of =SUM() over the filtered range?

--
Return email address is not as DEEP as it appears
"Sheryl" wrote in 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!!



  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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!!
.

  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Use the SUBTOTAL function, see help, for example if you use

=SUBTOTAL(9,B2:B500)

then filter on text in A2:A500 and

the aabove function will only sum visible cells as opposed to SUM(B2:B500)
which will always sum all rows


Regards,

Peo Sjoblom

"Sheryl" wrote:

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!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Autofilter - limitations? Kschu Excel Discussion (Misc queries) 3 April 19th 05 09:07 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 07:03 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:45 AM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 03:32 AM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"