Thread: NOT equal to
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
  
Posts: 84
Default NOT equal to
On 12/15/2017 at 11:34:42 AM Claus Busch wrote:

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.

Inexperienced Excel user here! :-)

What does the asterisk do in this part of the formula?

"<" &"*Project Management"

I don't think that it multiplies anything, right?

--
tb
Reply With QuoteReply With Quote