Posted to microsoft.public.excel.worksheet.functions

Picman

external usenet poster

Posts: 70

Calculate Filtered Cells Only

I have a list of value that i've built formulas to count the number of
occurrences of values that fall into curtain ranges. Now I what to filter the
data and do the calculations on the filtered values only, and not include the
other values.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Colored and filtered cells	Tony S.[_2_]	New Users to Excel	4	January 9th 08 11:53 PM
Calculating with filtered cells	Jo Davis	Excel Discussion (Misc queries)	5	November 15th 05 03:45 AM
filtered cells	minostrada	Excel Discussion (Misc queries)	3	September 21st 05 04:15 PM
Pasting onto filtered cells	Mediaexcel	Excel Worksheet Functions	1	October 27th 04 10:29 PM
Pasting onto filtered cells	Mediaexcel	Excel Worksheet Functions	1	October 27th 04 05:44 PM

All times are GMT +1. The time now is 01:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us