Hi,

Am Fri, 15 Dec 2017 07:22:31 -0800 (PST) schrieb
:

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.

the operator must be in quotes.
Try:
=SUMIF(D3:D49,"<*Project Management",C3:C49)
or
=SUMIF(D3:D49,"<" &"*Project Management",C3:C49)


Regards
Claus B.
--
Windows10
Office 2016