Operator for "Does not equal to"
=SUMIF(A2:A10,"<*London*",B2:B10)
if you want to reverse and get equal to something that contains London
=SUMIF(A2:A10,"*London*",B2:B10)
--
Regards,
Peo Sjoblom
"Milind Keer" wrote in message
...
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
|