not count if cell contains particular word. How do I do this?

I have a cell with a formula that counts cells in a column if another column has Tech Source in it...

=COUNTIFS($C12:$C10001,"=Tech Source",E12:E10001,"<>")

How do I do the opposite?  I would like it to count the column if it contains anything but Tech Source.  So...

Project Manager  5
Install                  5
Tech Source        3

I would like it to return a count of 2 (excluding the Tech Source row).

Kevin SmithAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
Are you looking for a SQL solution or Excel?

   SUM(CASE WHEN <condition> THEN 1 ELSE 0) END AS SomeCount
FROM myTable
GROUP BY SomeColumn
Kevin SmithAuthor Commented:
Na, an Excel formula...
Kevin SmithAuthor Commented:
Uh oh, just realized i put it in sql server area...
Scott PletcherSenior DBACommented:
I think this will do it:

,"<>Tech Source",

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.