Hi,

So to redo the previous thread in which it seems like you can't open up. I'll try my best to reiterate myself. Here's my problem and I thought it worked but once I tested it, it did not work. Here's my formula: Placements!$F:$F,"<>"&$C$7:$C$36

What I'm trying to attempt is when the data in Placements is refreshed (from a queue) and a value that is not listed from C7:C37 (this is my actual formula I need but the C7:C36 is a test) to pick up. My formula is part of a Sumifs, it is [criteria_range,criteria]. I am stumped beyond belief, I'm not sure on what I need to use. I'm figuring it may be a small error but I'm not sure..

Thanks!!!