Sumifs not equal to

I have a question and I thought I got it but it isn't working. I tested to see if it works and it clearly does not. Here's my formula: Placements!$F:$F,"<>"&$C$7:$C$36

This is my [criteria_range,criteria].

My actual formula would read Placements!$F:$F,"<>"&$C$7:$C$37. I am attempting in this formula for an "Other" so that when something new gets entered in or the Queue (Placements) picks up something when someone refreshes the data, this formula will pick it up. Basically if it doesn't fall into any of the values C7:C37 it will pick up. Hopefully that made sense, if not I can attempt to reword it.

Any help? Still stumped...

I had a feeling I didn't say what I was thinking. Okay, let me try again.

Placements is a separate spreadsheet. I'll show you the whole formula: =IF($A$1="",SUMIFS(Placements!$E:$E,Placements!$A:$A,">="&EOMONTH(TODAY(),-9)+1,Placements!$A:$A,"<="&EOMONTH(TODAY(),-8),Placements!$F:$F,"<>"&$C$7:$C$36,Placements!$D:$D,$B$1),IF($B$1="",SUMIFS(Placements!$E:$E,Placements!$A:$A,">="&EOMONTH(TODAY(),-8),Placements!$A:$A,"<="&EOMONTH(TODAY(),-9)+1,Placements!$F:$F,"<>"&$C$7:$C$36,Placements!$D:$D,$A$1)))

As you can see, it is quite long. Placements!$E:$E is basically the number of accounts uploaded onto the system on a specific date for each client. Placements!$A:$A is that specific date in which something was loaded on. Placements!$F:$F is a condition in which what collectors have used for a specific client. So basically $C$7:$C$37 is a whole list of these conditions. What I'm trying to do is if something is uploaded that doesn't follow/go under any of these conditions, it will pick it up. Eventually the small conditions that are rarely used will most likely go under this. I'm not trying to pull any other information from besides Column E for the number of accounts and Column F for the condition. We're trying to just get a look at what the collectors are using.

I'm sorry for the confusion... hope this helps.

Or what I'm trying to say "not follow/go under" is meaning it has yet to show up among the the conditions from C7:C37 and is a new condition.

No one is entering anything into Placements. The data is being pulled from a queue that is getting pulled from Artiva.

I have more clients than shown but I used the same number of conditions. The bold borders on the top left is a list, you can change the different clients from there. The spreadsheet is quite similar but obviously with no real values. If you look, it should be 100 instead of 0. I only used December 2014 as that's what my formula shows. Hope this helps!

example.xlsx

I'm guessing that there is no solution to it or?

Formula in L38, then dragged across

Please Login or Register  to view this content.