Re: Function Statements

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

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 23:54:12 -0000

=COUNTIF(Range,">=800000")-COUNTIF(Range,">1000000") 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Carolyn" <anonymous@discussions.microsoft.com> wrote in message
news:AE0AFCC2-F28D-4EFA-A86C-E3C8FE0ABEEC@microsoft.com...
> How can I write a function statement to calculate a range of informatin.  IE.,
a list of populations for cities, and I need to know how many cities have a
population between 800,000 and 1,000,000?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 10/02/2004

Relevant Pages

  • =?UTF-8?Q?Re=3A_K=D0=B0liningr=D0=B0dcy_protest_against_mosque_building?=
    ... reluctant to grant permissions for building mosques. ... building permission regulations make sense. ... support to those protesting against building Mosques in cities. ... However, out of all "anti-Mosque" protests I've heard about, the ...
    (soc.culture.baltics)
  • Re: Liverpools 56 number ones
    ... list does appear to contain all the large cities that non-Americans ... high number of successful acts? ... Here are the populations for the cities mentioned: ... New Orleans: 223,388 ...
    (rec.music.beatles)
  • Re: JOIN THE NRA !!
    ... You really think that countries like Sweden, ... Why don't you compare cities within a state where the same exact gun ... they are violent crime rates. ... the cities populations are not the ...
    (talk.politics.guns)
  • Re: If you were thinking about buying that Atlanta Thrashers jersey, you may want to act soon
    ... Right, let's put NHL teams in cities with populations of 403,000, ... 2010 Census tallies for other NHL cities (not metropolitan areas, ... Halifax averages 5,000 per QMJHL game, while Saskatoon, and Regina average ...
    (rec.sport.pro-wrestling)
  • Re: Liverpools 56 number ones
    ... list does appear to contain all the large cities that non-Americans ... number of successful acts? ... Here are the populations for the cities mentioned: ... New Orleans: 223,388 ...
    (rec.music.beatles)