Sumifs Not equal to

I'm having a problem with sumifs and <>, I am using a similar formula all throughout an excel doc and it's working great except when I try to exclude items. I've done this a number of ways, including setting a second column to take the column I'm referencing to make sure it's all in a general format and to make sure it was all in number format and this isnt working. I've tried referencing a cell containing the numbers, I've tried "<>"&"306688", but still can't seem to get the formula working.

Any ideas?

HTML Code: 

Here is a sample file: http://www.filedropper.com/book1_13

I know the sum wrap isn't necessary, but when I do an array it is so I kept it, however, I did try the formula without it.

I placed the formula in R1 in the example. The total SHOULD be showing me 8.17, showing me the N15 only, however, the formula is also including n13, ignoring my <>306688 reference.

Thank you!

Originally Posted by Tony Valko

The data in column B is TEXT even though most of it looks like numbers.

Here's what I did to get the correct result...

Select the range B2:B23
Goto the Data tab>Text to Columns>Click Finish

Note how the numeric data in column B is now aligned to the right.

The formula now returns the expected result.

Some of the data is going to be text as well. This info will all trigger from an automatic report, is there something I can put in the formula to counter this difference?