Thread: Criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
veryeavy veryeavy is offline
external usenet poster
 
Posts: 72
Default Criteria

Hi All,

Whilst I know the basics of criteria (in this case to be used in a DSUM
formula) and have looked at the examples in the Help system I am struggling
with this:

Say one of my criteria is:

Cost Center
5850

which I can also write as:

Cost Center
="=5850"

How can I write the criteria of not equal to 5850?

I have tried:

Cost Center
<5850

and

Cost Center
="<5850"

and neither seems to work.

Please help.

Thanks and Best Regards,

Matt