Re: NOT <> function

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

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

Date: Sat, 20 Mar 2004 00:59:33 -0500

It's simple but somewhat arcane; the kind of thing you learn from
experience. 

-- 
Vasant
"JB" <anonymous@discussions.microsoft.com> wrote in message
news:1077701c40e3d$e201f6f0$a401280a@phx.gbl...
> That seems simple enough.  Thanks for the response.
> Where can I find documentation for this type of
> question?  I searched help files and one reference book I
> trust. I searched MS web site also with no luck.
>
>
> Thanks again
>
> JB
>
>
> >-----Original Message-----
> >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
    ... > I don't understand why I have to type the word "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)