Can anyone help me please.

I have a problem with the criteria part of sumif using cell values.

I can type a value into a criteria directly in for example 2007, and it
works.

e.g. SUMIF(YEAR,2007,VALUE)

Where year and value are ranges.

But when I refer to a cell such as B12 which contains the value 2007, the
criteria doesn't work.

SUMIF(YEAR,B12,VALUE)

Does the cell reference need to be MARKED in any way?

George Humphries