Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Comparison Operator "" NOT "=" | Excel Discussion (Misc queries) | |||
Is it possible to apply IF's to "operator" result.. | Excel Discussion (Misc queries) | |||
program stuck at "Save Cancelled by Operator" | Excel Discussion (Misc queries) |