Re: NOT <> function

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

From: Vasant Nanavati (vasantn)
Date: 03/20/04 

Date: Fri, 19 Mar 2004 23:31:50 -0500

Because the criterion has to be in the form of a string. You can use:

"<>"&C5

instead of:

"<>Vermont"

if you prefer. 

-- 
Vasant
if you prefer
"JB" <anonymous@discussions.microsoft.com> wrote in message
news:d9a001c40e2b$2df378d0$a601280a@phx.gbl...
> I don't understand why I have to type the word "Vermont"
> in the formula using <>"Vermont" and I can just use the
> cell reference (or just click in the cell) for the
> formula that totals the amount in Vermont
>
>  Anderson Sales
>  Client List
>
>
>  Anderson $22,401 Vermont
>  Axelton 32,145 Massachusetts
>  Boxter 58,956 New Hampshire
>  Byrnes 10,057 Rhode Island
>  Carter 98,475 Rhode Island
>  Cooper 66,547 Massachusetts
>  Dexter 98,574 Vermont
>  Dymes          10,358 Vermont
>  Earnes 62,478 Massachusetts
>  Everston 20,588 Rhode Island
>  Falk          33,657 Maine
>  Forkner 55,894 Maine
>
>
>
>  Amount of Sales in Vermont         131,333
>  =SUMIF(C5:C16,C5,B5:B16)
>
>  Amount of Sales not in Vermont     438,797
>  =SUMIF(C5:C16,"<>Vermont",B5:B16)
>
>

Relevant Pages

  • Re: NOT <> function
    ... >>> formula that totals the amount in Vermont ... >>> Anderson Sales ... >>> Axelton 32,145 Massachusetts ... >>> Byrnes 10,057 Rhode Island ...
    (microsoft.public.excel.worksheet.functions)
  • Re: A pozwolcie ze ...
    ... though -- it comprises of 6 states: ... Massachusetts, Vermont. ... Rhode Island, New Hampshire, Maine, and ...
    (soc.culture.polish)
  • Re: Most states youve visited in a day?
    ... New York, Connecticut, Massachusetts, Rhode Island, New Hampshire and ... Vermont. ...
    (rec.sport.pro-wrestling)
  • Re: NOT <> function
    ... I searched help files and one reference book I ... >> formula that totals the amount in Vermont ... >> Byrnes 10,057 Rhode Island ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Smoothbore vs. Rifled Muskets
    ... "With the old musket, round bullet, and 120 grains of powder, the initial ... the initial velocity to 963 ft. ... research as to what 0.577 rifle-musket the US used around 1860), ...
    (rec.games.frp.dnd)