Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
criteria 1(a,b,c), criteria 2 (T,F) - Results (3 answers) achievab | Excel Discussion (Misc queries) | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |