I think the SUBTOTAL function is more specific. >From Help....... SUBTOTAL Calculates subtotals. If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.
Syntax: SUBTOTAL(function; range) Function is a number that stands for one of the following functions: Function index Function 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP Range is the range whose cells are included. Example: You have a table in the cell range A1:B5 containing cities in column A and accompanying figures in column B. You have used an AutoFilter so that you only see rows containing the city Hamburg. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be: =SUBTOTAL(9; B2:B5) On Fri, 2006-02-03 at 11:36 +1100, Ross Johnson wrote: > There is COUNTIF(range;criteria) > > e.g. > COUNTIF(A1:A100;"=10000") > or > COUNTIF(A1:A100;B1) where B1 contains 10000 > > On Fri, 2006-02-03 at 12:01 +1300, Paul wrote: > > To answer the original question. OOo calc does not support that > > functionality (ie, display number of records that were returned in the > > filter). > > > > You can of course raise an enhancement request which may be included > > in later releases of OOo... > > > > /paul > > > > On 2/3/06, David Chapman <[EMAIL PROTECTED]> wrote: > > > Counting unique entries in a range... > > > > > > http://www.openofficetips.com/blog/archives/2005/08/counting_unique.html > > > > > > On 2/2/06, Michael <[EMAIL PROTECTED]> wrote: > > > > > > > > Welsh-Huggins, Andrew wrote: > > > > > I need some help related to OpenOfficeCalc. > > > > > > > > > > On Excel, if I autofilter and then select a category, (say, the number > > > > > of $10,000 donations in a column of contributions), Excel will tell me > > > > > how many of that particular number in the lower left hand corner > > > > > automatically. (e.g., "72 of 3,000 records found.") > > > > > > > > > > OpenOfficeCalc won't do that for me; does anyone know if it can, and > > > > > if > > > > > so, how to activate it? > > > > > > > > > > Thanks. > > > > > > > > > > Andrew Welsh-Huggins > > > > > > > > I have a similar situation. I have a sheet full of addresses, sorted > > > > by postal code. I would like to know 1) the number of unique postal > > > > codes and 2) the number of records in each postal code. Does Calc > > > > have functions to do this? > > > > > > > > Cheers > > > > M > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > -- > > > My OpenOffice Calc Website > > > http://www.openofficetips.com > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
