=sum(countifs(range,{not this, not this, nor this} -How to exclude criteria in this manner

I am trying to figure out how to get my "Other" Column. I have countifs set for 4 categories, and need a 5th as a catch-all for those not specifically called out. I have tried a few things that I've come up with, but I keep getting formula errors with the pieces within the bracket.

Anyone able to save the day for me?

how about simpley taking the sum of the others away from the total?
=O9-SUM(J9:M9)
Then change the total to
=SUM(J9:M9)

Also, to aid in copying the other formula down and across, a small change...
=COUNTIFS($C$2:$C$935, J$8, $D$2:$D$935, $I$9)

Not sure where that calculation is meant to go. However, the easy way is to "count everything" and then take away the sum of the things you can specifically count.

Regards, TMS

How about this in N9:

Please Login or Register  to view this content.

and then copied down.

BAM.

Reviving the thread for one last question.

Not sure about reviving it. There's no indication that it was ever marked solved or that you thanked anyone for offering a solution.

You had three answers within one hour of asking your question. And here you are, three weeks later, and don't even comment on the previous replies ... good or bad. Why would anyone want to pick it up again? I, for one, will not be offering an answer.

I think it might be easiest at this point to use your solution.

I didn't provide a solution; I offered a suggestion which, in effect, was what Ford gave you a formula for. I may have been using my iPad at the time, in which case I would not have been able to see the workbook properly (rows/columns/formulae) so I wouldn't have been in a position to offer a specific answer.

So, maybe my answer didn't merit a thank you, a +rep or a comment of any kind. I can understand that priorities may, and often must, change ... but three weeks is a long time, especially in the world of the computers, tablets, smart phones and the Internet.

To quote the forum rules:

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

I would suggest you mark this thread as solved, open a new thread for the new question, cross referring to this thread for background. Or just provide the current workbook and an explanation of the issue(s) and progress.

That will open the thread up to new input. The current thread with input from a Mod, a Guru and VFC, and a non-zero post count probably won't attract much passing interest.

You're welcome. Thanks for the rep.