Thanks a lot guys.... i didnt' know formulas in XL does support wild
characters... lack of knowledge... :)

Answer to David's question,

Does not eual to is the term XL is using in custom filter and thats why i
used that.

Basically... i want to exclude one word (which i know already) from the
cell...
like,
in above example i want to exclude "London" from Name and City column...

Thanks for all you help guys...
Milind Keer



"ShaneDevenshire" wrote:

Hi,

The question David asks important. However assuming it is not, then:

=SUMIF(G8:G12,"*London",H8:H12)

Where the name&city are in column G and the amounts in H.

To make it more flexible:

=SUMIF(G8:G12,A1,H8:H12)

and in A1 enter *London

--
Cheers,
Shane Devenshire


"Milind Keer" wrote:

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