View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Milind Keer[_2_] Milind Keer[_2_] is offline
external usenet poster
 
Posts: 46
Default Operator for "Does not equal to"

Is there any operator for "Does not equal to" like < is for "Not Equal To"
and = is for "Equal To"

I have a coloum with Name and City together
e.g. Mike - London, John - Leeds, Martha - London etc etc

Now I want only Exclude London Based people to calculate total salary for
remaining

My Table looks like below

Name&City--------------- Salary
Mike - London---------------100
John - Leeds-----------------300
Martha - London-------------200
Rita - Leed-------------------100
Geeta-Manchester-----------200

Now I want to exclude London bases people and calculate (SUM) salary of
other people.

Here result should be - 600