On Monday, January 14, 2008 at 4:43:03 PM UTC-5, Neon520 wrote:
How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

I am trying to use the SUMIF function. And it is not accepting the < as not equal function. Here is the formula that is giving the error:

=SumIF(D3:D49,<"*Project Management",(C3:C49))

I am basically trying to sum up the rows for all entries that are not Project Management.

--

STATEMENT OF CONFIDENTIALITY:

This email may be confidential and/or protected by privilege. If you are
not the intended recipient, disclosure, copying, distribution and/or use
are prohibited; please notify us immediately at and
delete this copy from your system.