Hello!

Have used this forum many times and it has been so useful, but now I'm really stuck and I can't find any answers on here so thought I would ask my first question!

I have attached a spreadheet that should sum the value in column G based on the value of column A* however it seems to think that "1-02" & "2-14" are the same number and sums it all?!?!

Im guessing that this is a date thing maybe?? But does anybody have an idea of how i can get around this as I cant change the code and I need a seperate sum of each code?

Many Thanks in advance for all your help.

Sam



SUMIF Error.xlsx