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]
