NOT <> function

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

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)
 
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
 
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
 
Back
Top